Create a JOB Scheduler:

Create Job Using DBMS_SCHEDULER:

BEGIN

DBMS_SCHEDULER.CREATE_JOB (

JOB_NAME => 'JOB_CYC_CNT_RQLN',

JOB_TYPE => 'PLSQL_BLOCK',

JOB_ACTION => 'BEGIN PROC_INS_CYC_CNT_RQLN; END;',

START_DATE => SYSTIMESTAMP,

REPEAT_INTERVAL => 'FREQ=DAILY;BYHOUR=10;BYMINUTE=05',

END_DATE => TO_TIMESTAMP ('10-Sep-2099 14:10:10.123000', 'DD-Mon-YYYY HH24:MI:SS.FF'),

ENABLED => TRUE,

COMMENTS => 'CYC_CNT_RQLN');

END;

 

Query to Find the Running Jobs:

select * from user_scheduler_jobs;

 

Query to Find the Status of the Running Query:

SELECT     JOB_NAME,STATUS,

    ERROR#,

    REQ_START_DATE,

    ACTUAL_START_DATE,

    RUN_DURATION,

    ADDITIONAL_INFO

FROM     USER_SCHEDULER_JOB_RUN_DETAILS

WHERE     JOB_NAME LIKE 'JOB_CYC_CNT_RQLN';

 

Query to Drop the Running Jobs:

begin

DBMS_SCHEDULER.DROP_JOB('JOB_CYC_CNT_RQLN');

end;

 

Query to Interrupt the Running Job:

BEGIN

DBMS_SCHEDULER.STOP_JOB ('JOB_CARD_SCHED');

END;