Reading the scheduler log
The Scheduler log can record the details of scheduled and completed batch imports and exports - the actual events that are logged will depend on the logging options set on the Schedules page of the iBase Scheduler Configuration dialog. Activity for each database connection is logged to the same file.
- Click the Schedules tab to display Schedules page.
- Click View Log to display the Log Viewer, and then click the required entry. This displays full details at the bottom of the Log Viewer.
- To update the display in the Log Viewer, click Refresh.
Completion status
The different statuses for scheduled tasks are shown in the following table. To display the status in the Log Viewer, click on the row you are interested in.
| Completion status | Description |
|---|---|
| Task execution successful | The task ran successfully. |
| Trigger updated | The trigger has been edited. |
| Trigger inactive | The trigger has been made inactive and will not run again until you make it active. |
| Trigger expired | This batch import or export did not run because the end date on the File Change type trigger had passed. |
| Trigger deleted |
The trigger has been deleted. Also, the task was scheduled but was canceled by the service because the trigger had expired. This might happen, for example, if a previous task took much longer to run than expected. Notice that scheduled tasks are not canceled if the end time is in the past. |
| Error | The task was not completed successfully. |
Scheduled batch imports and exports that fail
If the logging option When tasks are scheduled to run is selected, entries are added to the log for tasks that are scheduled to run in the future.
The file associated with a file trigger does not have to exist; the task will still be scheduled and an entry appear in the log. If the file does not exist or if the permissions on the folder containing the file prevent viewing of the date and time of the file then these messages will be logged once every 24 hours:
- The file X does not exist or there are insufficient permissions on the directory it is located in to read the file.
- The File Change trigger file X does not exist or there are insufficient permissions on the directory it's located in to read it.
Completed batch imports and exports
To prevent a type of message from appearing in the log, display the Schedules page, and click to turn off the required Logging option, as described in the table below in the Log Description section.
| Column | Description |
|---|---|
| Date & Time | Timestamp recorded when this phase of the batch import or export was started or completed. Most recent events are listed first. |
| Connection Name | Name of the connection to the iBase database. |
| Task Name, Task Type | Name of the task that has been scheduled, and its type. |
| Trigger Name, Trigger Type | Name of the trigger that scheduled the task, and its type: Interval or File Change. |
| Log Type |
The log type corresponds to the logging options set on the Schedules page:
|
| Log Description | The messages detail, in reverse order, the progress of the task. For example:
|