Installation guide

10.9.1.1 Upgrading Job Scheduler Templates

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

Context

Note

Several changes impact the Job Scheduler templates. These changes make some templates incompatible with

earlier versions of the server. The current templates are version 3.0 in the XML files.

Procedure

1. Disable Job Scheduler.

2. Update any environment variables, scripts, or applications that refer to the Job Scheduler directory path. The

Job Scheduler directory is under the ASE-16_0 directory, in $SYBASE/$SYBASE_ASE/jobscheduler .

Directories below jobscheduler remain the same.

3. Copy files from the jobscheduler directory to the ASE-16_0 directory. If you are installing the new server

directories over the old server directories, the installer automatically moves your files to the new

jobscheduler directory.

4. If you modified SAP-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 SAP template files, or better yet, rename your

modified templates.

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 the SQL code in the jobs created from the

templates.

Table 8: Changed Job Scheduler Templates

Template Modified Files Datatype for <parameter> Changed

from varchar(5) to int

dump database

jst_dump_databases

@use_srvr_name

dump database

log

jst_dump_log

@truncate_flag and

@use_srvr_name

update

statistics

jst_update_statistics

@index_flag

rebuild indexes

jst_reorg_rebuild_indexes

@dump_flag

Installation Guide for Linux

SAP ASE Upgrades