Re: How to run a task continuously in the background

From: lilu <lixiao_fly(at)126(dot)com>
To: Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)de>
Cc: "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 07:08:37
Message-ID: 3C9E7EFE-2655-487B-AC54-62BF27CADEC4@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 在 2019年7月12日,下午1:06,Dirk Mika <Dirk(dot)Mika(at)mikatiming(dot)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(dot)mika(at)mikatiming(dot)de <mailto:dirk(dot)mika(at)mikatiming(dot)de>
> www.mikatiming.de <http://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> <https://youtu.be/qfOFXrpSKLQ>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Durumdara 2019-07-12 07:32:04 Aggregated join vs. aggregate in column?
Previous Message Toomas Kristin 2019-07-12 06:44:38 Machine learning top of db logs