rs_scheduler_file_events
The following table lists the columns for the rs_scheduler_file_events view. The equivalent jcs_scheduler_file_events view is available for backward compatibility reasons. The difference between the two is the data type of the date/time columns; the rs_* views use TIMESTAMP WITH TIME ZONE while the jcs_* views use DATE.
Column | Datatype | Description |
SCHEDULER_PARTITION | VARCHAR2 | The partition of the scheduler |
SCHEDULER_NAME | VARCHAR2 | The name of the scheduler |
FILE_NAME | VARCHAR2 | A (wildcard) filename specification that must exist |
EVENT_PARTITION | VARCHAR2 | Partition of the event raised when the file exists |
EVENT_NAME | VARCHAR2 | Name of the event raised when the file exists |
MOVE_DIRECTORY | VARCHAR2 | A directory where a detected file should be moved to |
TEST_UNLOCKED | VARCHAR2 | Test for file locks on the detected file before reporting it? |
CHECK_INTERVAL | NUMBER | Interval in seconds for event agent to check this file |
LAST_RAISED | NUMBER | Time of the last file that raised this event (in seconds since 1970 in OS context) |
STATUS | VARCHAR2 | The status of the file event |
plsqlTopic
onsiteTopic