how to force broken job to run?
ski123Oct 14 2008 — edited Oct 15 2008Oracle 9.2
We have a job which runs daily and failed yesterday. So we set up broken=Y in dba_jobs table so that it won't run until we find the problem, then we will enable it.
This morning we want to force job scheduler to run this job. syntax is as follows:
sql>exec dbms_job.broken(JOB=>197587, NEXT_DATE=>SYSDATE + 1/24*60*60, broken=>FALSE);
Do I need to use commit after this syntax?
Please give me some ideas. thanks.
Jin