Database Administration (MOSC)

MOSC Banner

how to reset next_run_date of a Scheduler job

edited Jan 19, 2012 6:32PM in Database Administration (MOSC) 3 commentsAnswered
Hi,

How can I reset the next_run_date of a job in the Scheduler?

For example, I have a job which is running every 10 seconds. I want to stop it now and let it run again in let's say an hour. I tried changing the start_date and repeate_interval attributes with no luck.

Oracle 10g R1

MyUser@MyDB> SELECT to_char(NEXT_RUN_DATE, 'dd-Mon hh12:mi:SS am tzr') NEXT_RUN_DATE
  2  FROM DBA_SCHEDULER_JOBS
  3  WHERE job_name='TESTME';
 
NEXT_RUN_DATE
---------------------------------------------------
20-Jan 11:12:00 AM +11:00
 
MyUser@MyDB>
MyUser@MyDB> EXEC DBMS_SCHEDULER.DISABLE('TESTME');
 
PL/SQL procedure successfully completed.

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