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 10.2.0.2 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Goal

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.

Solution

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
Goal
Solution
 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
References

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