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