Enable Scheduler Job Execution - Oracle 11g: Cont'd

After enabling job execution on the database you might want to check the status of individual scheduler jobs. 

This can be done by querying DBA_SCHEDULER_JOBS.

SQL> select job_name, state from dba_scheduler_job where job_name = 'test_job';

JOB_NAME                    STATE

--------------------------- ---------

TEST_JOB                    DISABLED

As seen above, test_job will not run as scheduled because it us disabled. To enable test_job run;

SQL> BEGIN 

    DBMS_SCHEDULER.ENABLE('schema1.test_job'); 

END;

/

You can also can check the progress of currently running jobs by querying ALL_SCHEDULER_RUNNING_JOBS or DBA_SCHEDULER_JOBS.

Hope this helps!

Kehinde.