Home » RDBMS Server » Server Administration » How ro migrate scheduled jobs ?
How ro migrate scheduled jobs ? [message #250762] Wed, 11 July 2007 04:01
mganesh
Messages: 1
Registered: July 2007
Junior Member
Hi,

There is a requirement where the scheduled jobs in one database are to be copied/migrated to another database. The version is 10g/Windows. We are using dbms_Scheduler.

In the absence of source job scheduling scripts and OEM, is there a way to recreate the scripts for these jobs from some dba_* views so that we could run the same on the target database to recreate the jobs?

The requirement is urgent...

Thanks.

Report message to a moderator

Previous Topic: Maintain Logical Transaction Integrity in a High Availability ODS
Next Topic: 2 same Oracle SID on a same server having two versions of oracles.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 22:48:25 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.