| From: | Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de> |
|---|---|
| To: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: How to run a task continuously in the background |
| Date: | 2019-07-12 05:06:14 |
| Message-ID: | D49B7AAD-5EC3-4D62-A263-E22E6633C807@mikatiming.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
[cid: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(dot)mika(at)mikatiming(dot)de
www.mikatiming.de
AG Köln HRB 47509 * WEEE-Reg.-Nr. DE 90029884
Geschäftsführer: Harald Mika, Jörg Mika
[cid:CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg]<https://youtu.be/qfOFXrpSKLQ>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brent Wood | 2019-07-12 05:22:11 | Re: How to run a task continuously in the background |
| Previous Message | Dirk Mika | 2019-07-12 05:00:24 | Re: How to run a task continuously in the background |