Which table in Oracle is OScommand jobs held?
Hi,
I am just in the process of tracking down what I think is a rouge OScommand job. However which table is it in in Oracle? I have looked in the ALL_JOBS view and I can't see it. I know I can see it in the Enterprise Manger (see below). I am using Oracle 11g R2.
Thanks
Mike
I am just in the process of tracking down what I think is a rouge OScommand job. However which table is it in in Oracle? I have looked in the ALL_JOBS view and I can't see it. I know I can see it in the Enterprise Manger (see below). I am using Oracle 11g R2.
Thanks
Mike
Naveen Kumar
try this : DBMS_SCHEDULER
ASKER
Thanks - I have just had a read through the Oracle documentation and it tells me at great length how to set up jobs, but what if I want to see what jobs are already set up?
When I use SQL Developer and log on as SYSDBA and look under the Schedules/Programs/Jobs folder the MIKE_TEST job is not there.
Sorry if I'm missing something really obvious.
Mike
When I use SQL Developer and log on as SYSDBA and look under the Schedules/Programs/Jobs folder the MIKE_TEST job is not there.
Sorry if I'm missing something really obvious.
Mike
dba_scheduler_programs
dba_scheduler_schedules
dba_scheduler_jobs
dba_scheduler_schedules
dba_scheduler_jobs
ASKER
Thanks but when I select from those tables the MIKE TEST job does not exist in them.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I set it up in the screen shot. Does that answer your question?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
hydev,
Can I ask why you accepted the solutions as you did? http:#a36548100 is asking a question and does not appear to provide any real asssitance.
Can I ask why you accepted the solutions as you did? http:#a36548100 is asking a question and does not appear to provide any real asssitance.