Oracle8i Replication Management API Reference
Release 2 (8.1.6)

Part Number A76958-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Data Dictionary Views, 89 of 112


DEFSCHEDULE

Contains information about when a job is next scheduled to be executed.

Column  Datatype  NULL  Description 

DBLINK 

VARCHAR2(128) 

NOT NULL 

Fully qualified pathname to the master database site for which you have scheduled periodic execution of deferred remote procedure calls. 

JOB 

NUMBER 

 

Number assigned to job when you created it by calling DBMS_DEFER_SYS.SCHEDULE_PUSH. Query the WHAT column of the USER_JOBS view to determine what is executed when the job is run. 

INTERVAL 

VARCHAR2(200) 

 

Function used to calculate the next time to push the deferred transaction queue to destination. 

NEXT_DATE 

DATE 

 

Next date that job is scheduled to be executed. 

LAST_DATE 

DATE 

 

Last time the queue was pushed (or attempted to push) remote procedure calls to this destination. 

DISABLED 

CHAR(1) 

 

If Y then propagation to destination is disabled.

If N then propagation to the destination is enabled. 

LAST_TXN_COUNT 

NUMBER 

 

Number of transactions pushed during last attempt. 

LAST_ERROR_NUMBER 

NUMBER 

 

Oracle error number from last push.  

LAST_ERROR_MESSAGE 

VARCHAR2(2000) 

 

Error message from last push. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index