Re: How to run a task continuously in the background

Поиск
Список
Период
Сортировка
От lilu
Тема Re: How to run a task continuously in the background
Дата
Msg-id 3C9E7EFE-2655-487B-AC54-62BF27CADEC4@126.com
обсуждение исходный текст
Ответ на Re: How to run a task continuously in the background  (Dirk Mika <Dirk.Mika@mikatiming.de>)
Ответы Re: How to run a task continuously in the background  (Tim Clarke <tim.clarke@minerva.info>)
Список pgsql-general

在 2019年7月12日,下午1:06,Dirk Mika <Dirk.Mika@mikatiming.de> 写道:

 
A cron job will only run once a minute, not wake up every second. 
 
Right, that’s an issue.
 
But you could write a PHP program that does a one-second sleep before checking if there's something to do, and a batch job that runs periodically to see if the PHP program is running, and if not, launch it.  
 
I would like to avoid external programs if possible. In the current Oracle environment, there are potentially multiple schemas on a server in which processing can be active. And processing can be started, monitored and stopped from a client application. And only for the schema with which the application is connected.
 
BR
Dirk
-- 
Dirk Mika
Software Developer

<image001_d0a5cf51-5dd3-4ff5-b428-1016a6d95a0f.png>

mika:timing GmbH
Strundepark - Kürtener Str. 11b
51465 Bergisch Gladbach
Germany

fon +49 2202 2401-1197 
dirk.mika@mikatiming.de
www.mikatiming.de

AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884 
Geschäftsführer: Harald Mika, Jörg Mika

<CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg>


В списке pgsql-general по дате отправления:

Предыдущее
От: Toomas Kristin
Дата:
Сообщение: Machine learning top of db logs
Следующее
От: Durumdara
Дата:
Сообщение: Aggregated join vs. aggregate in column?