Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: -- scheduled timer process if power is off?

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

From: Romeo Olympia <rolympia_at_hotmail.com>
Date: 15 Jun 2004 03:04:17 -0700
Message-ID: <42fc55dc.0406150204.6570b4d0@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US