how to reset next_run_date of a Scheduler job
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.