Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to know if a Job is activated

Petri BRNov 9 2010 — edited Nov 9 2010
What's a standard way to look if a job in some data base is activated?


I know that the query bellow show me the information of the job.

SELECT *
FROM DBA_JOBS
WHERE JOB = &job_number

But what do I need to check to know if it's activated?
Do I look the NEXT_DATE field?

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 7 2010
Added on Nov 9 2010
7 comments
211 views