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

Andre wrote:
>
> 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

Effectively the jobs scheduled start date "expires" - so any job that was going to run during the power outage will immediately run when the database retarts. You can control this with your job. If a job is scheduled for 5pm and should only start somewhere around this time slot, then you could submit a string such as:

'if to_char(sysdate,''HH24'') between ''16'' and ''19'' then

    my_proc;
 end if;'

hth
connor

-- 
Connor McDonald
Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
ISBN: 1590592174

web: http://www.oracledba.co.uk
web: http://www.oaktable.net
email: connor_mcdonald_at_yahoo.com

Coming Soon! "Oracle Insight - Tales of the OakTable"

"GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
and...he will sit in a boat and drink beer all day"

------------------------------------------------------------