Filter
Top Products
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.