Job Scheduling

Поиск
Список
Период
Сортировка
Искать

Job Scheduling

От:
Majid Azimi <majid.merkava@gmail.com>
Дата:
Hi guys.

Do we have a feature in postgresql so that we can schedule some 
activities? or we should use other tools.
I want to add a job so that it creates a new table as a partition of 
main table each month
and updates (INSERT, UPDATE, DELETE) triggers in the main table.
Is there any feature to do this or i should use cron?

Re: Job Scheduling

От:
Steve Crawford <scrawford@pinpointresearch.com>
Дата:
On 03/10/2011 09:43 AM, Majid Azimi wrote:
> Hi guys.
>
> Do we have a feature in postgresql so that we can schedule some 
> activities? or we should use other tools.
> I want to add a job so that it creates a new table as a partition of 
> main table each month
> and updates (INSERT, UPDATE, DELETE) triggers in the main table.
> Is there any feature to do this or i should use cron?
>
Nothing built-in. Use cron - that's what it's for.

Cheers,
Steve

Re: Job Scheduling

От:
Andreas Kretschmer <akretschmer@spamfence.net>
Дата:
Majid Azimi  wrote:

> Hi guys.
>
> Do we have a feature in postgresql so that we can schedule some  
> activities? or we should use other tools.
> I want to add a job so that it creates a new table as a partition of  
> main table each month
> and updates (INSERT, UPDATE, DELETE) triggers in the main table.
> Is there any feature to do this or i should use cron?

No and yes, you have to use cron.


Andreas
-- 
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."   (unknown)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°
FAQ