1 person found this helpful
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.
P.S. Assigning the new Schedule to a job:
DBMS_SCHEDULER.set_attribute (name => 'MY_OLD_JOB',
attribute => 'schedule_name',
VALUE => 'MY_NEW_SCHEDULE');