Sybase 15.0.2 User Manual
Page 96
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.