Database Administration (MOSC)

MOSC Banner

Job not stop when i want

edited Mar 10, 2011 9:41AM in Database Administration (MOSC) 2 commentsAnswered
 Hi ,
I want to planify a job in Calendar Syntax with the next conditions.
This job has to be executed all days, since tomorrow, every 5 minutes, since 8:03 until 23:03.
I have tried this definition:
STARTDATE=(SYSDATE +1 at 08:03)
FREQ=MINUTELY;INTERVAL=5;
BYHOUR=8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23;
But the job is also executed at 23:08, 23:13, 23:18, ...

Can you please suggest me to stop the job at 23:03 hrs.


Thanks&regards
Prem

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center