Re: -- scheduled timer process if power is off?

I assume you're referring to the dbms_job facility.

If so, then for your case, your jobs will be submitted when your database is turned on. dbms_job checks for all jobs that should have run during the downtime and executes them after startup.

Take care that the job's next_date doesn't "slide" away from the 1st day of the month at 17:00 hrs. Maybe a parameter of

INTERVAL => 'ADD_MONTHS(TRUNC(SYSDATE, 'MM'), 1) + 17/24' Cheers.

avanrossem_at_hotmail.com (Andre) wrote in message news:<4d32d1be.0406142141.63cde585_at_posting.google.com>...
> Hello all,
>
> I have a scheduled job which starts at 17:00 hours on the first day of
> the month. Now it is possible that on this day (if it's in the
> weekend) the server is not on. What is going to happen if the server
> is switched on one day later. Does the job run afters startup??
> Is the job ignored and will the job run on the first day of the next
> month?
>
> Thanks for all answers!
>
> Regards,
> Anneke
> The Netherlands
Received on Tue Jun 15 2004 - 05:04:17 CDT