Greetings,

I need a database process to be triggered daily, before any user begins
using the system.

A natural solution could be to schedule a script execution at the desired
time. But the server will not be always on-line, so it could be off at the
time the script should execute.

I was thinking in an alternative solution. Whenever a user connects to the
system, it would be verified the last time the process
executed successfully on the database. The process would only execute if
it wasn't yet executed today.

Does anybody adopted a similar solution? What could be the majors
vantages/disvantages?

Thanks.

---------------------------
Martin D. Berezaga
mdberezaga@...
ICQ : 18537142
Porto Alegre - RS - Brasil
---------------------------

----------


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.483 / Virus Database: 279 - Release Date: 19/05/03


[Non-text portions of this message have been removed]