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.
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:
  


Current Time: Mon Dec 02 09:38:29 CST 2024