OraFAQ Forum: Enterprise Manager » Is it possible to transfer jobs from one oem instance to another?

Home » RDBMS Server » Enterprise Manager » Is it possible to transfer jobs from one oem instance to another?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Is it possible to transfer jobs from one oem instance to another? [message #68488]

Thu, 27 November 2003 03:04

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

Report message to a moderator

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

Frank Naude
Messages: 4581
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 06:39:47 CST 2024