How to know if a Job is activated
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.