Name
DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION
Synopsis
When you need to stop the propagation of deferred calls to a given destination, you can do so with theUNSCHEDULE_EXECUTION procedure.
PROCEDURE DBMS_DEFER_SYS.UNSCHEDULE_EXECUTION
(dblink IN VARCHAR2);dblink is the global name of the destination database.
Calling this procedure is analogous to calling DBMS_JOB.REMOVE to remove the job that SCHEDULE_EXECUTION scheduled. The job is removed from the queue, and automatic propagation to the database specified by dblink ceases. Whenever you remove a master definition site, call UNCHEDULE_EXECUTION for the site.
There are no restrictions on calling UNSCHEDULE_EXECUTION.
Exceptions
Exception Name | Number | Description |
|---|---|---|
NO_DATA_FOUND | –01403 | Specified destination is not in the DEFSCHEDULE data dictionary view. |