Thread: Job Scheduling

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?

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

Majid Azimi <majid.merkava@gmail.com> 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°