Sybase 15.0.2 User Manual
Page 95
CHAPTER 5 Upgrading Adaptive Server
Installation Guide
81
v
Upgrading Job Scheduler templates
1
Disable Job Scheduler before ugrading Job Scheduler 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. New location is
$SYBASE/$SYBASE_ASE/jobscheduler.
Directories below jobscheduler remain the same.
3
If you have any of your own files in the old Job Scheduler directory, copy
them to the new 15.0.2 directory. If you are installing Adaptive Server over
the old server directories, the installer will have moved your files to the
new jobscheduler directory already.
4
If you have modified any of the Sybase-supplied templates stored
procedures or XML documents, do not overlay the new templates with
your versions. If you do, you will 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
Sybase recommends that if you modify Sybase-supplied templates
that you 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
v
archar(5)
to
int
. The following table lists the templates that changed in
version 2.1 and the changes you need to make to jobs created from them.
Table 5-1: 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.