Name

DROP_SCHEDULE

Synopsis

This procedure drops a named schedule.

Parameter name

Datatype

Description

schedule_name

VARCHAR2

Name of the schedule to be dropped.

force

BOOLEAN

If the schedule is referenced by a job or a window, then you cannot drop it. If this parameter is set to TRUE, it will disable the job or the window and then drop the schedule. Default is FALSE.

Get Oracle PL/SQL for DBAs now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.