Oracle Distributed Systems

Name

DBMS_DEFER_SYS.SCHEDULE_PUSH (Oracle8 Only)

Synopsis

The SCHEDULE_PUSH procedure schedules automatic pushes to the destination node.

PROCEDURE DBMS_DEFER_SYS.SCHEDULE_PUSH(
   destination IN VARCHAR2,
   interval IN VARCHAR2,
   next_date IN DATE,
   reset IN BOOLEAN := FALSE,
   parallelism IN BINARY_INTEGER := NULL,
   heap_size IN BINARY_INTEGER := NULL,
   stop_on_error IN BOOLEAN := NULL,
   write_trace IN BOOLEAN := NULL,
   startup_seconds IN BINARY_INTEGER := NULL,
   execution_seconds IN BINARY_INTEGER := NULL,
   delay_seconds IN BINARY_INTEGER := NULL,
   transaction_count IN BINARY_INTEGER := NULL );

Parameters

Parameter Name	Description
destination	Global name of the destination database.
interval	Frequency with which to execute the call.
next_date	First time to push transactions queued for destination.
reset	If TRUE, last_txn_count, last_error, and last_msg are nulled in DEFSCHEDULE data dictionary view for this destination.
parallelism	Degree of parallelism: 0 = serial (no parallelism) 1 = parallel propagation with one slave n = parallel propagation with n slaves
heap_size	If > 0, maximum number of transactions to examine simultaneously for parallel scheduling computation. If 0, compute this number based on parallelism parameter.
stop_on_error	If TRUE, stop on the first error, even if not fatal.
write_trace	If TRUE, record the result in a trace file.
startup_seconds	Maximum number of seconds to wait for the completion of a previous push to the same destination.
execution_seconds	Maximum number of seconds to spend on the ...