How I can add the force option in stoping job with this proc
Hi, I have this procedure. and I want to add force option in this line dbms_scheduler.stop_job('"'||message.object_owner||'"."'|| message.object_name ||'"'); but I don't know how I can do that.
Thanks
Denis
CREATE OR REPLACE procedure sniper_proc
(message IN sys.scheduler$_event_info) as
base_name varchar2(30) := 'FLIGHT_FARE_MV';
switch_job varchar2(30);
l_ind_running varchar2(01) := 'Y';
begin
-- if this is not a JOB_OVER_MAX_DUR message, error out
if message.event_type != 'JOB_OVER_MAX_DUR' then
raise PROGRAM_ERROR;
end if;
-- stop the job