dbms job get offlin automaitcally
Hi,
my dbms_job get automaticall offline which is scheduled monthly.when i make it online by using toad just click on PLACE ONLINE button then it becomes online after some time it will be offline automatically.why is it happening ? i say commit while closing toad . after that i go to sql and log in through sysdba and execute
sql>EXEC dbms_job.broken(jobno, FAlSE);
*
ERROR at line 1:
ORA-23421: job number 182 is not a job in the job queue
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 86
ORA-06512: at "SYS.DBMS_IJOB", line 529
ORA-06512: at "SYS.DBMS_JOB", line 245
ORA-06512: at line 1
Any advice,suggestions will be higly appreciated.
Best Regards