Introduction

The automatic scheduling and execution of tasks in CONNECT are performed by the scheduler. The scheduler is a windows service that it installed separately from CONNECT. This service will get a list of jobs and determine every hour if any need to run for that hour. It will then queue them up and send them to the web service to run at the appropriate time. 

Pre Requisites

Some features of the scheduler require "Power User" status.

Tracking Completed Schedule Jobs

Power User → Tools → Exception Viewer

Whenever a scheduled job runs, be it scheduled or manually kicked-off, the history of it's execution will be logged to the "AppException" table in CONNECT. To view these records, open the "Exception Viewer form". We can find these by looking for the "Scheduled Task" messages.

Selecting one of these lets us view it in detail. We can see in the message that it tells us the ID of the scheduled job, the code for the job, and the time it was started and completed. If there were parameters set for the job we will see them in the "Stack Trace" column.

Records will only be created here if the job ran to completion. If the job fails for any reason we will not see log records here, but will instead need to check for error messages on this screen, or in the error logs. Logging these completions to a table means we can now write custom tasks that check for these run jobs and send emails or exception reports to admins when they do not run. 

Logging Exceptions From Scheduling

Prior to version 1.09.19.4 any errors encountered or logging messages for the service were sent to the Windows Event Viewer. As of this version, these errors and logs are sent to the log files.