Sybase ADAPTIVE 15.0.2 User Manual
Page 96
Upgrading Job Scheduler
80
Adaptive Server Enterprise
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-2: 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.