Skip to Main Content

Breadcrumb

Warning

Before you submit your comment...

Remember - this is about feedback to the original question. AskTOM is about building a strong Oracle community, not stealing time away from others needing assistance by sneaking in a brand new question under the guise of "Comment".

If your comment requires a response that might include a query, please supply very simple CREATE TABLE and INSERT statements. Nice simple scripts so we can replicate your issue simply.

Remember to take a look at Legal Notices and Terms of Use before supplying a comment...

Don't forget, your comments are public. If you want to send a comment to just the AskTOM team, please use the feedback option

Comment

Highlight any SQL, PL/SQL, or fixed-width text and click the <code> button
 (will never be published or used to spam you)

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 100+ 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