Upgrading Job Scheduler
82 Adaptive Server Enterprise
6 Some Job Scheduler templates were modified to support new 15.0.2
Adaptive Server functionality. The changes are related to new parameters
for specifying a partition name or a datachange value for the Adaptive
Server command that have added these options. If you have jobs created
from any of the enhanced templates, modify the SQL of the jobs for 15.0.2
servers.
Note If you have a job scheduled to run on a pre-15.0.2 server and you
need it to run on 15.0.2 servers too, leave the existing job alone and create
a new job for 15.0.2 servers as the job commands will be different.
Jobs intended to run on pre-15.0.2 servers do not need to be modified. The
following table lists the templates that changed in version 3.0 and the
changes you need to 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
will be scheduled on pre-15.0.1 servers; you must use the 2.1 or 2.2
versions for pre-15.0.1 servers.
Table 5-2: Modified Job Scheduler templates
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.
Template Modified files Change description
Modify jobs created
from this template
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.
