Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Oracle

Posted Mar 18, 2002

Listen Software's How To: Job Management

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;


Oracle Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM