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

XMAS_TREE

The AskTOM team is taking a break over the holiday season, so we're not taking questions or responding to comments. Please have a happy and safe festive season and as always, thanks for being a member of the AskTOM community.

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)

We're not taking comments currently, so please try again later if you want to add 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

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Scheduler

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