Oracle Distributed Systems

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, ...