Templates provide one more way to ease the management of your Adaptive Server databases. A template helps database administrators to create T-SQL scripts that perform specific database tuning and maintenance tasks; the T-SQL that it creates becomes the T-SQL text for the job itself. These jobs can subsequently be customized to a particular server and scheduled to run on any network server at any specified time. As a result, templates can save database administrators the work of creating their own T-SQL or cron scripts, freeing them to concentrate on other duties.
When you use the Sybase Central ASE plug-in, a wizard leads you through each step to create the T-SQL that invokes the procedures for managing your databases.
When you create a job from a template that uses stored
procedures, the stored procedures must exist on the server on which
the job runs. See “Installing stored procedures on a target server” for more information.
