Copy DBMS scheduler job from one user to other

COPY command is used to copy the dbms scheduler jobs

Following example copy the MY_JOB from SCOTT user to HR User

exec dbms_scheduler.copy_job('SCOTT.MY_JOB','HR.MY_JOB');

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply