Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 81
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-3: Modified Job Scheduler templates
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.
update
statistics
SybUpdateStatsTemplate.xml
jst_update_statistics
Added @ptn_name as
fifth parameter and
@datachg_threshold as
the 10th parameter and
added reference
Required, modify job SQL
to include values (or NULL)
for new parameters.
rebuild indexes SybRebuildIndexTemplate.xml
jst_reorg_rebuild_indexes
Added @ndx_ptn_name
as third parameter.
Required, modify job SQL
to include value (or NULL)
for new parameter.
reclaim indexes SybReclaimIndexTemplate.xml
jst_reclaim_index_space
Added @ptn_name as
third parameter
Required, modify job
SQLto include value (or
NULL) for new parameter.
reclaim tables SybReclaimTableTemplate.xml
jst_reclaim_table_space
Added @ptn_name as
second parameter
Required, modify job SQL
to include value (or NULL)
for new parameter.