Hi Tom,
I have a scheduler which is linked to my package. The package was running for long and hence I cancelled the task. Now when I try to run the package back, the scheduler is not running.

I checked in "USER_SCHEDULER_JOB_LOG" AND THE MESG IS

"REASON="ORA-01014: ORACLE shutdown is progress"

and the STATUS is "STOPPED"


My Scheduler code that I used is

BEGIN
DBMS_SCHEDULER.CREATE_JOB
( job_name => 'batch_error',
job_type => 'PLSQL_BLOCK',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=secondly; interval=10;',
job_action => 'common_pipe_send_receive_pkg.common_pipe_receive_error_proc;',
enabled => true
);
END;
/

Please advise me?

Thank you,
Priya

exec dbms_scheduler.disable('BATCH_ERROR');
exec dbms_scheduler.enable('BATCH_ERROR');