Skip to Main Content
  • Questions
  • How to move the Jobs(Present in user_scheduler_jobs table) from one User to another User ,Present in the same DB server

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, vinesh.

Asked: September 21, 2020 - 6:15 pm UTC

Last updated: October 07, 2020 - 2:20 am UTC

Version: Oracle Database 11g Release 11.2.0.4.0 - 64bit

Viewed 1000+ times

You Asked

Team,



Very Good Monday Morning !!



The Version of Oracle we use is :

Oracle Database 11g Release 11.2.0.4.0 - 64bit


No peculiar data or table design requried over here .

This request is on behalf of Data and DB Objects Migration in our project.

we have 2 users by name User_1 and User_2 present in the same DB Server.

Entire Data Migration including table data, procedures,function,views ,sequence etc ....apart from Scheduled jobs has been done.

User_1 has 5 Jobs by name Job_1,Job_2,Job_3 ,Job_4 and Job_5

These Jobs are available under the system table user_scheduler jobs, with their corresponding procedure names, start time ,time of execution, status etc.


Now I would like to move these 5 Jobs into User_2.

Can someone just how to move these jobs from User_1 to User-2 from a PL/SQl Developer Perspective.


Thanks and Regards !!

and Connor said...

Use

select dbms_metadata.get_ddl('PROCOBJ','YOUR_JOB_NAME') from dual;


which will give you the full DDL for the job in your schema.

This can then be run in any schema you like

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Thank You Note !!

A reader, October 06, 2020 - 8:10 am UTC

Thanks for your solution
Connor McDonald
October 07, 2020 - 2:20 am UTC

glad we could help

More to Explore

Scheduler

All of the database utilities including the Scheduler are explained in the Utilities guide.