Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to move the Jobs(Present in user_scheduler_jobs table) from one User to another User ,Present in

Satyam ReddySep 21 2020 — edited Sep 22 2020

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.

Thanks and Regards !! 

This post has been answered by GregV on Sep 21 2020
Jump to Answer
Comments
Post Details
Added on Sep 21 2020
8 comments
796 views