Home » RDBMS Server » Enterprise Manager » Is it possible to transfer jobs from one oem instance to another?
Is it possible to transfer jobs from one oem instance to another? [message #68488] Thu, 27 November 2003 03:04 Go to next message
Marc
Messages: 26
Registered: August 1999
Junior Member
Hi,

We have installed OEM on a new server and would like to copy the jobs from our old oem server. Can it be done?

Sincerely,
Marc
Re: Is it possible to transfer jobs from one oem instance to another? [message #68489 is a reply to message #68488] Fri, 28 November 2003 03:54 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
Hi,

Unfortunately there is no supported way to copy jobs between OMS servers. If you have a lot of time, you may want to see what OMS tables contain job related information, and try to re-insert the required rows into the target repository.

SQL> select table_name from user_tables where table_name like '%JOB%';

TABLE_NAME
------------------------------
EPC_CLI_JOB
SMP_VAR_EBU_ACTIVE_JOB_
SMP_VAR_EBU_SAVED_JOB_
SMP_VAR_OS_ACTIVE_JOB_
SMP_VAR_OS_SAVED_JOB_
SMP_VAR_SMR_ACTIVE_JOB_
SMP_VAR_SMR_SAVED_JOB_
SMP_VBO_JOB_CONFIG_TABLE
SMP_VDG_JOBID_MAP
SMP_VDJ_JOB
SMP_VDJ_JOB_LOCK
SMP_VDJ_JOB_LOG
SMP_VDJ_JOB_LOG_COMMENT
SMP_VDJ_JOB_LOG_INTERMED
SMP_VDJ_JOB_OUTPUT
SMP_VDJ_JOB_PER_TARGET
SMP_VDJ_JOB_TARGET
SMP_VDO_JOBID_SERVICEID

18 rows selected.


Best regards.

Frank
Previous Topic: Intelligent Agent doesn't start
Next Topic: Viewing in Instance Manager
Goto Forum:
  


Current Time: Wed May 18 15:25:48 CDT 2022