• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 411
  • Last Modified:

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
0
hydev
Asked:
hydev
  • 3
  • 3
  • 2
2 Solutions
 
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
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
dba_scheduler_programs
dba_scheduler_schedules
dba_scheduler_jobs
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
hydevAuthor Commented:
Thanks but when I select from those tables the MIKE TEST job does not exist in them.
0
 
Naveen KumarProduction Manager / Application Support ManagerCommented:
Are you using scheduler or dbms_jobs ?
0
 
hydevAuthor Commented:
I set it up in the screen shot.  Does that answer your question?
0
 
slightwv (䄆 Netminder) 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now