Setting up the logging options

Details of batch imports and exports for each database connection can be logged in the Scheduler database. You control the level of detail by setting the logging options on the Schedules page of the Scheduler Configuration dialog; these can be different for each database connection. Nothing is recorded if no logging options are set.

Procedure

To set the logging options for a database connection:

  1. Click the Schedules tab to display the Schedules page.

  2. Select the required database connection. By default, all the logging options are selected when the database connection is created.

  3. In the Logging Options area, turn on or off any of the following logging options. Your changes take effect immediately.

    • When tasks are scheduled to run

      The date and time that the next batch import or export will run. This provides a useful confirmation that the task and trigger are set up correctly as the Scheduler service will add a log entry for the scheduled import or export the next time that the service runs.

    • When tasks start and finish

      When the batch specification started and finished running.

    • When task actions start and finish

      The startup and shutdown of programs and plug-ins that run before or after the import or export.

    • When components start and finish

      The start and finish of individual specifications in the batch specification. (For example, an import specification is a component of a batch import specification.)

    • Statistics when a component finishes

      The number of records that are added, updated, unchanged, or result in errors for the main entity, or the link end entities, in the specification (component).

      For a link import, will also include the number of records added, updated, unchanged or result in errors for the link itself.

      For an export, will include the number of records exported.

    • The completion status when a task finishes

      Whether the batch specification ran successfully or whether there was a problem and, if so, what the status of the scheduled task is.

    • Warnings, Errors

      Any warnings and errors generated by the batch import or export.