OracleDB‎ > ‎

Job

Oracle Jobs

Create a job to run every 15 minutes to execute statspack.snap

First login as the user who is suppose to run the job, then run the following.

DECLARE X NUMBER; BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => 'statspack.snap;' ,next_date => sysdate ,interval => 'TRUNC(SYSDATE+15/1440,''MI'')' ,no_parse => TRUE ,force => TRUE ); END; /

set job queue to zero

SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;

Comments