{"repo":"RekGRpth/pg_task","free":true,"listed":false,"github":"https://github.com/RekGRpth/pg_task","clone":"git clone https://github.com/RekGRpth/pg_task.git","description":"pg_task - job scheduler for PostgreSQL, Greenplum and Greengage: asynchronous background execution of SQL commands at user-defined time","language":"C","stars":68,"topics":["postgres","job","scheduler","async","background","sql","task","c","greenplum","postgresql"],"license":"MIT","category":"databases-storage","readme_excerpt":"PostgreSQL, Greenplum and Greengage job scheduler pg task allows to execute any sql command at any specific time at background asynchronously first second pg task creates the following GUCs: Name Type Default Level Description --- --- --- --- --- pg task.delete bool true config, database, user, session Auto delete task when both output and error are nulls pg task.drift bool false config, database, user, session Compute next repeat time by stop time instead by plan time pg task.header bool true config, database, user, session Show columns headers in output pg task.save bool false config, database, user, session Save session state between tasks pg task.spi bool false config, database, user, session SPI (or local) execution? pg task.string bool true config, database, user, session Quote only strings pg conf.fetch int 10 config, database, superuser Fetch conf rows at once pg conf.max int max worker processes config Maximum task and work workers pg conf.restart int 60 config, database, superuser Restart conf interval, seconds pg task.count int 0 config, database, user, session Non-negative maximum count of tasks, are executed by current background worker process before exit pg task.fetch int 100 config, database, user Fetch task rows at once pg task.id bigint 0 session Current task id (for read only) pg task.limit int 1000 config, database, user Limit task rows at once pg task.max int 0 config, database, user, session Maximum count of concurrently executing tasks in group, negativ","default_branch":null,"files":null,"tree":[],"storefront":"/r/RekGRpth","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/RekGRpth/pg_task/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}