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!

Rename DBMS_SCHEDULER job

user8525647Nov 30 2017 — edited Dec 6 2017

Hello

We need to rename some jobs in production environment. These are dbms_scheduler jobs.

I tried using- rename <old_job> to <new_job_name> and it worked. I want to understand, what is the ideal way of doing this and implication.

Should we stop and drop the old job and then create a new job with desired name or can simply do it with rename command.

We are using Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit

Thanks

This post has been answered by Paulzip on Nov 30 2017

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 28 2017

Added on Nov 30 2017

5 comments

3,476 views