begin
dbms_scheduler.stop_job('<JOB_NAME>',true);
end;
example
begin
dbms_scheduler.stop_job('PRJ_EMP_UPDATE',true);
end;
once after stopping the job, we can disable it from the PL/SQL developer.
dbms_scheduler.stop_job('<JOB_NAME>',true);
end;
example
begin
dbms_scheduler.stop_job('PRJ_EMP_UPDATE',true);
end;
once after stopping the job, we can disable it from the PL/SQL developer.
No comments:
Post a Comment