2 Replies Latest reply: Mar 14, 2014 12:39 PM by miersuzzemes RSS

    Is it possible to rename a dmbs schedule?

    miersuzzemes

      DBMS_SCHEDULER:

      Just like the question about renaming jobs:Rename a scheduled job

      But there is no option to copy schedules, so is there a way?

        • 1. Re: Is it possible to rename a dmbs schedule?
          GregV

          Hi,

           

          You can't rename a schedule. You'll need to drop and create it with its new name. But if there are dependant jobs you'll receive an error when dropping it. So assign the new schedule to the dependant jobs and then drop the current one.

          • 2. Re: Is it possible to rename a dmbs schedule?
            miersuzzemes

            P.S. Assigning the new Schedule to a job:

             

            BEGIN

               DBMS_SCHEDULER.set_attribute (name       => 'MY_OLD_JOB',

                                                                   attribute   => 'schedule_name',

                                                                   VALUE    => 'MY_NEW_SCHEDULE');

            END;

            /