[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 409
  • 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 Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
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

Featured Post

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.

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