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');Copy DBMS scheduler job from one user to other
Leave a reply
Smart way of Technology 