Listen Software Solutions' "How To" Series:
Creating an Oracle Job
By David Nishimoto
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;
Back to the LSS "How To" Series Main Page
|
