Re: How to run a task continuously in the background
Dirk Mika <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
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 [email protected] 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>
image001_d0a5cf51-5dd3-4ff5-b428-1016a6d95a0f.png
(image/png, 1.7 KB) - not displayed
CCh2U_f27a5ce6-8556-4db1-8aa4-fd610d6e9efe.jpg
(image/jpeg, 107.2 KB) - not displayed