On Thursday 19 July 2007 00:03:19 Roderick A. Anderson wrote:
> I'll post my solution ... when I figure one out!
You could, in the script from cron:
1 - check for the presence of rows in a 'alive_scripts_table'
if any , then exit, and go for the next run,
alternativly, check that pid in 'ps -ef' so there actually is a script running
2 - create a record in a table, ie insert your pid into a alive_script_table,
3- do your thing
4 - delete your row from the alive_script_table
or use above with a file instead
or just check with ps/tasklist/wmic
--
/Björn
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
