Custom scheduling allows a set of user specified
SQL queries and cost / duration calculations to be run automatically at the beginning and end of the scheduling process. The queries are run when creating and updating
Scheduled Tasks, and when updating active
Incidents. Such queries may be used to transfer data from asset to survey objects for example.
Note: Only database owners can modify custom scheduling settings when user
permissions are enabled.
The points at which a query / calculation will be run are:
- Immediately after a scheduled task has been created from the
Create Scheduled Tasks dialog.
- Immediately after a repeated scheduled task has been created by the
Update Scheduled Tasks process.
- When updating a completed task or incident that has not yet been closed.
InfoAsset Manager assumes that most organisations will normally work with just one set of scheduling queries. For this reason the custom scheduling queries are applied at the database level by default. However, it is possible to override the database custom scheduling on a per network basis.
To change the current custom scheduling for the database:
- Select
Database management | Custom scheduling from the
File menu (available when no networks are open). This displays the
Custom Scheduling dialog.
- Enable the
Run custom scheduling as database owner check box if required.
- For every of these three sections :
Operations to run when new tasks are scheduled,
Operations to run on active tasks when scheduled tasks are updated and
Operations to run on completed tasks when scheduled tasks are updated, click the
Show button to expand the section.
- Drag in any
SQL queries (or use the
button to browse for any queries) that are to be automatically run
Note: Custom scheduled queries that are subsequently deleted will not be run when the relevant task creation or update is performed on the contrary to queries that have been renamed. In both cases, when the Custom Scheduling dialog is accessed, a warning log is displayed to the user with details of the deleted or renamed queries. See
Custom Scheduling dialog topic for more details.
- Select the desired calculating and overwriting option for costs and durations in the
Built in options section.
- Click
OK to apply changes.
To change the current custom scheduling for the current network:
- Select
Scheduling | Custom scheduling from the
Network menu to display the
Custom Scheduling dialog.
- Enable the
Run custom scheduling as database owner check box if required.
- For every of these three sections :
Operations to run when new tasks are scheduled,
Operations to run on active tasks when scheduled tasks are updated and
Operations to run on completed tasks when scheduled tasks are updated, click the
Show button to expand the section.
- Drag in any
SQL queries (or use the
button to browse for any queries) that are to be automatically run
- Select the desired calculating and overwriting option for costs and durations in the
Built in options section.
- Click
OK to apply changes.