My Oracle Support Banner

How to Create a Job in Enterprise Manager Database Control (10g and 11g) (Doc ID 1567285.1)

Last updated on JUNE 12, 2017

Applies to:

Enterprise Manager for Oracle Database - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.


This article shows how to create a simple OS job and a simple SQL Script job in Enterprise Manager (EM) Database Control. 
If there are any problems running any of the EM jobs, it is always a good idea to test a relatively simple host job (for example, one that performs a directory listing) or simple Sql script job (for example, one that performs a select * from dual). 
Often problems with more complex jobs can have the same root cause as a simple job in the EM job system, but it is much easier to troubleshoot a simple job.
Note that the Database Control version follows the target database version served by it.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1) Which jobs can be run in Enterprise Manager Database Control? 
 2) Setting the Credentials
 3) How to create a job
 a) To create an OS job:
 b) To create a sql script job:
 c) How to view the job output:
 5) How to check the job activity for "Refresh_From_Metalink_job" or "RefreshFromMetalink"? 
 6) Where is the job library?
 7) Other References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.