Scheduled programs in postgresql

[monicamariahernandez]

Hi,
Does anybody knows if it is possible to schedule a program in postgresql? I mean, I want to run the same sql (or script with some sqls), at the same time, every day.

Any clue?
Thanks

 

[sleipnir214]

How about a cron job? ______________________________________________________________________
TANSTAAFL!

 

[Leland123]

Hi monicamariahernandez,

It would depend on which OS your running. If your running Linux, take a look at "cron". You would need to have crond (e.g. the cron daemon) running in memory. If your using Linux you could do:

man cron

This would bring up the manual on cron which has a ton of options.

This should get you started. Leland F. Jackson, CPA
Software - Master (TM)

https://www.smvfp.com

Nothing Runs Like the Fox