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

 Example OSCommand
hydevAsked:
Who is Participating?
 
Naveen KumarConnect With a Mentor Production Manager / Application Support ManagerCommented:
Are you using scheduler or dbms_jobs ?
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
try this : DBMS_SCHEDULER
0
 
hydevAuthor Commented:
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
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
Naveen KumarProduction Manager / Application Support ManagerCommented:
dba_scheduler_programs
dba_scheduler_schedules
dba_scheduler_jobs
0
 
hydevAuthor Commented:
Thanks but when I select from those tables the MIKE TEST job does not exist in them.
0
 
hydevAuthor Commented:
I set it up in the screen shot.  Does that answer your question?
0
 
slightwv (䄆 Netminder)Connect With a Mentor Commented:
As these are OS commands, the doc points to saving them to a LIBRARY.

http://download.oracle.com/docs/cd/E11857_01/em.111/e16790/jobs.htm#BABGBBDE

I cannot find where/how Oracle stores or references this.  I did find a view called DBA_LIBRARIES but I don't have any OS command libraries set up so I cannot confirm if this is the view.
0
 
slightwv (䄆 Netminder) Commented:
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.
0
All Courses

From novice to tech pro — start learning today.