How to obtain the Job details - Parameters / Scripts from the Grid Control Repository (Doc ID 601554.1)

Last updated on APRIL 15, 2016

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.3 to 11.1.0.1 [Release 10.2 to 11.1]
Enterprise Manager for Oracle Database - Version 11.2.0.2 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.
Checked for relevance on 10-AUG-2011
Checked for relevance on 13-Feb-2013

Goal

At present, there is no option to export the details of a Job from the Grid Control Repository.
This document provides steps to extract the Job information - parameters, scripts from the repository directly via SQL queries. If necessary the emcli tool (submit_job option) can be used to create the same job in another EM setup.

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms