Tag Archives: job

Manage Oracle JOB

Manage Oracle JOB

 

Create a JOB to run a certain procedure once a day for example, run the following script in SQLPLUS.

jobno variable number;
instno variable number;
begin
dbms_job.submit (: jobno,
‘BEGIN Nome_da_Procedure; END; ‘
, trunc (sysdate) +3/24,
‘SYSDATE + 1,
TRUE
);
END;
/

To check the scheduled jobs.

SELECT * FROM dba_jobs;

To check if it is running.

select * from dba_jobs_running;

To delete jobs.

DELETE FROM WHERE dba_jobs job = 99;

To check when was the last execution.

select JOB, LAST_DATE, LAST_SEC, NEXT_DATE, NEXT_SEC, INTERVAL, FAILURES from dba_jobs;

 

Back to previous menu