My Oracle Support Banner

EM 12c: An Example of a Simple SQL Job Configuration with Execution in Enterprise Manager 12c Cloud Control (Doc ID 2281235.1)

Last updated on FEBRUARY 20, 2020

Applies to:

Enterprise Manager Base Platform - Version 12.1.0.5.0 and later
Information in this document applies to any platform.

Goal

Described below is an example of a simple SQL job configuration and execution in Enterprise Manager (EM) 12.1.0.5 Cloud Control.

 

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
  Check by setting up a simple SQL Job as follows:
 1-    Cloud Console > Enterprise > Job > Activity
 2-    Create Job
 3-    Choose Target Type > SQL Script
 4-    Select > Add the Job Name > choose the DB Name
 5-    Choose Parameter Tab
 6-    Add the Credentials by choosing the Credentials Tab
 7-    Choose Schedule Tab > One Time (immediate)
  8-    Press on Submit > a message displayed, the Job <job name> is created
 9-    Job Success shows that the EM Job System is working

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