Name
DBMS_DEFER_SYS.SCHEDULE_EXECUTION
Synopsis
If you are using the advanced replication facilities or if your application queues deferred RPCs on a continual basis, then you should schedule the calls to the EXECUTE procedure at prescribed intervals for each destination. The SCHEDULE_EXECUTION procedure does just that by placing calls to the EXECUTE procedure in the job queue.
PROCEDURE DBMS_DEFER_SYS.SCHEDULE_EXECUTION (dblink IN VARCHAR2, interval IN VARCHAR2, next_date IN DATE, reset IN BOOLEAN default FALSE, stop_on_error IN BOOLEAN := NULL, transaction_count IN BINARY_INTEGER := NULL, execution_seconds IN BINARY_INTEGER := NULL, execute_as_user IN BOOLEAN := NULL, delay_seconds IN NATURAL := NULL, batch_size IN NATURAL := NULL);
The SCHEDULE_EXECUTION procedure does not raise any exceptions nor are there any restrictions on calling this procedure.
Parameters
Parameter Name | Description |
---|---|
dblink | Global name of the destination database. |
interval | Frequency with which to execute the RPC. |
next_date | First time to execute transactions queued for dblink. |
reset | If TRUE, then last_txn_count, last_error, and last_msg are nulled in DEFSCHEDULE data dictionary view for this dblink. |
stop_on_error | If not NULL, value is used by the call to EXECUTE. |
transaction_count | If not NULL, value is used by the call to EXECUTE. |
execution_seconds | If not NULL, value is used by the call to EXECUTE. |
execute_as_user | If not NULL, value is used by the call to DBMS_DEFER_SYS.EXECUTE (obsolete in Oracle8). |
delay_seconds | If not NULL, ... |
Get Oracle Distributed Systems 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.