Upgrading Job Scheduler Templates

After upgrading to the new server, upgrade the templates and jobs created by Job Scheduler templates.

1. Disable Job Scheduler before upgrading the templates.
2. Update any environment variables, scripts, or applications that refer to the Job Scheduler directory path. The Job Scheduler directory has been renamed and moved beneath the ASE-15_0 directory. The new location is $SYBASE%\$SYBASE_ASE/jobscheduler .

   Directories below jobscheduler remain the same.

3. Copy files from the jobscheduler directory to the new ASE-15_0 directory. If you are installing the new server directories over the old server directories, the installer moves your files to the new jobscheduler directory automatically.
4. If you modified Sybase-supplied templates, stored procedures, or XML documents, do not overlay the new templates with your modified versions. If you do, you lose the enhancements provided by the revised templates. Carefully merge your template changes into the Sybase template files, or better yet, rename your modified templates.
   Note:

   If you modify Sybase-supplied templates, save the changes under new names and in new files.

5. You may need to make minor modifications to jobs you created from 2.0 or earlier templates. In some templates, parameters changed from varchar(5) to int. The following table lists the templates that changed in version 2.1 and the changes you must make to jobs created from them.

   Changed Job Scheduler Templates

   Template	Modified files	Change description	Modify jobs created from this template
   dump database	SybBackupDbToDiskTemplate.xml jst_dump_databases	Changed the datatype for the @use_srvr_name parameter from varchar(5) to int	Required, modify job SQL to change @use_srvr_name to int datatype.
   dump database log	SybBackupLogToDiskTemplate.xml jst_dump_log	Changed the datatype for the @truncate_flag and @use_srvr_name parameters from varchar(5) to int	Required, modify job SQL to change @truncate_flag and @use_srvr_name to int datatype.
   update statistics	SybUpdateStatsTemplate.xml jst_update_statistics	Changed the datatype for the @index_flag parameter from varchar(5) to int	Required, modify job SQL to change @index_flag to int datatype.
   rebuild indexes	SybRebuildIndexTemplate.xml jst_reorg_rebuild_indexes	Changed the datatype for the @dump_flag parameter from varchar(5) to int	Required, modify job SQL to change @dump_flag to int datatype.
   rebuild table	SybRebuildTableTemplate.xml jst_reorg_rebuild_tables	Changed the datatype for the @dump_flag parameter from varchar(5) to int	Required, modify job SQL to change @dump_flag to int datatype.
   reclaim indexes	SybReclaimIndexTemplate.xml jst_reclaim_index_spac	Required, modify job SQL to change @dump_flag to int datatype.	Required, modify job SQL to change @resume_flag to int datatype.
   reclaim tables	SybReclaimTableTemplate.xml jst_reclaim_table_space	Changed the datatype for the @resume_flag parameter from varchar(5) to int	Required, modify job SQL to change @resume_flag to int datatype.

6. Some Job Scheduler templates were modified to support the new server functionality. These changes are related to new parameters for specifying a partition name or a datachange value for the new server commands that added these options. If you have jobs created from any of the enhanced templates, modify the SQL of the jobs for the 15.5 servers.
   Note:

   If you have a job scheduled to run on a pre-15.5 server and you need it to run on 15.5 servers too, leave the existing job alone and create a new job for 15.5 servers as the job commands are different.

   Jobs intended to run on pre-15.5 servers do not need to be modified. The following table lists the templates that changed in version 3.0 and the changes you must make to jobs created from them.

   Note:

   All templates listed below, except Delete Statistics, are incompatible with pre-15.0.1 servers. Do not use them to create jobs that are scheduled on pre-15.0.1 servers; you must use the 2.1 or 2.2 versions for pre-15.0.1 servers.

   Modified Job Scheduler Templates

   Template	Modified file	Change description	Modify jobs created from this template
   delete statistics	SybDeleteStatsTemplate.xml jst_delete_statistics	Added @ptn_name as third parameter.	Optional.
   update statistics	SybUpdateStatsTemplate.xml jst_update_statistics	Added @ptn_name as fifth parameter and @datachg_threshold as the 10th parameter and added reference	Required, modify job SQL to include values (or NULL) for new parameters.
   rebuild indexes	SybRebuildIndexTemplate.xml jst_reorg_rebuild_indexes	Added @ndx_ptn_name as third parameter.	Required, modify job SQL to include value (or NULL) for new parameter.
   reclaim indexes	SybReclaimIndexTemplate.xml jst_reclaim_index_space	Added @ptn_name as third parameter	Required, modify job SQL to include value (or NULL) for new parameter.
   reclaim tables	SybReclaimTableTemplate.xml jst_reclaim_table_space	Added @ptn_name as second parameter	Required, modify job SQL to include value (or NULL) for new parameter.
   multiple	jst_get_freespace,jst_get_usedspace	Replace reserved_pgs and data_pgs with reserved_pages and data_pages	No impact on job SQL.

7. Install the template stored procedures and and move them to the Job Scheduler template stored procedure directory. For example:

   cd $SYBASE/$SYBASE_ASE/jobscheduler/Templates/sprocs

   1. Run the stored procedure install script for each server being upgraded:

      installTemplateProcs <servername> <username> <password>

      Note:

      Template stored procedures should be upgraded on all Job Scheduler servers and target servers that are upgraded to Adaptive Server version 15.5. Do not install them on pre-15.5 servers.

8. Install the template XML documents. Move to the JS template XML directory. For example:

   cd $SYBASE/$SYBASE_ASE/jobscheduler/Templates/xml

   1. Run the XML install script on 15.0.1 servers with Job Scheduler installed:

   installTemplateXml <servername> <machinename> <serverport>
       <username> <password> [<language_code>]

   Use “en” for the language_code or omit the parameter completely as “en” is the default.
   Note:

   Template XML should be upgraded on all Job Scheduler servers upgraded to Adaptive Server version 15.0.1. Do not install them on pre-15.0.1 servers or servers where Job Scheduler is not installed.