Examples of how to use the snapshot process to create stored procedures that run as jobs, how to run an existing job, how to remove a job from the job queue, and how to review job status.
Create a Job
VARIABLE v_jobnum NUMBER;
Run an Existing Job
Remove a Job from the Job Queue
Review Job Status
select * from user_jobs;
select * from dba_jobs_running;