Unix Administrator with Vertias Cluster Server The Computer Merchant, Ltd US-IL-Joliet Post A Job | Post A Resume

Create a Job

     VARIABLE v_jobnum NUMBER;

     BEGIN

     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