The
Maintenance Task Scheduler allows you to schedule scripts to run against local server configurations. The
Maintenance Task Scheduler provides you with the ability to automate performance improvements on your database on a schedule that you choose. You can
run scripts that will update query optimization statistics and online index rebuilding.
Here are some items to consider when using the
Maintenance Task Scheduler:
- You cannot modify scripts or add to the list of scripts.
- If a script or folder containing the scripts is moved and there is a schedule for the script set,
StarTeam Server will still attempt to run the script but it will log an error.
- You can provide a
Recurring schedule for your scripts. This gives you the flexibility to run scripts at different times. You can also run scripts ad
hoc.
- Script execution is logged in a file called
execScript.log, located at the same location as the server log.
- It is not possible to schedule scripts remotely through the
Server Administration tool. This only works for local configurations.
- You can define a new script schedule while the server configuration s running. The modification will be picked up after about
30 seconds.