Database Administration (MOSC)

MOSC Banner

How I can add the force option in stoping job with this proc

edited Nov 1, 2017 5:01AM in Database Administration (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center