Database Job Scheduler

The Database Job Scheduler tool allows your organization to run SQL scripts at specified intervals to update data in the system. Organizations use this tool to update records with values based on defined rules or formulas that may not be populated through data entry or import processes.

For example, an organization might use this tool to update prefixes on work orders generated through the Service Requester or update the work order sub-status field based on defined criteria.

SQL Statements can also be defined to run based on the occurrence of events, using the Rules Manager: Run Database Script action.

The Database Job Scheduler also allows you to view the status of all executed SQL. This view displays SQL defined in the Database Job Scheduler and the Rules Manager.

View the status of executed SQL:

1. Select Tools > System > Database Job Scheduler from the Main Menu.

   The Database Job Scheduler opens.

2. Click the Rule-Based Jobs tab to view recently executed SQL.

   A summary of executed SQL displays. The list includes the date and time the SQL was executed, the code that was executed, and the status.

   The Database Job Scheduler is typically configured by Maintenance Connection Implementation Staff. Contact Maintenance Connection for more information on this feature.