Create a Job

     VARIABLE v_jobnum NUMBER;

     BEGIN
         dbms_job.submit(:v_jobnum,
         'my_stored_procedure;', sysdate,'sysdate+1');
     END;

Run an Existing Job

     dbms_job.run(job_number);

Remove a Job from the Job Queue

     dbms_job.remove(job_number);

Review Job Status

     select
     job,
     log_user,
     priv_user,
     schema_user,
     next_date,
     next_sec,
     interval,
     failures,
     total_time,
     what
     from dba_jobs;

     select * from user_jobs;

     select * from dba_jobs_running;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 噗噗噗的潛水珽 的頭像
    噗噗噗的潛水珽

    潛水珽的異想世界

    噗噗噗的潛水珽 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄