how can I locate a Scheduler job?
574131Sep 4 2007 — edited Sep 5 2007Hi there,
In the alert log, I see the following error :
ORA-12012: error on auto execute of job 2915
My question is - how do I find the definition for job 2915?
And before you say - "that's easy, it's in all_scheduler_jobs", it's
not in all_scheduler_jobs. The old dbms_job package had a column for
job number, but the Scheduler doesn't. I've scrutinized the definition for
all the Scheduler views, but nothing reveals the job number.
When I look at all the jobs listed in dba_scheduler_jobs, nothing seems
likely to be this mysterious job 2915.
Does anyone have any idea how I can locate it?
Thanks!
Paul Stuart