Filter
Top Products
CHAPTER 5 Upgrading Adaptive Server
Installation Guide 79
go
alter database sybmgmtdb LOG on sybmgmtdev=20
go
9 Upgrade the sybmgmtdb. Using isql, run the installjsdb script that is
included with this release and save the output to a file:
isql -Usa -Psa_password -Sservername -n
-i$SYBASE/$SYBASE_ASE/scripts/installjsdb
-ooutput_file
10 Enable Job Scheduler to start when Adaptive Server starts. From isql enter
the command:
sp_configure "enable job scheduler", 1
11 Start Job Scheduler. From isql enter the command:
sybmgmtdb..sp_js_wakeup "start_js", 1
go
Upgrading Job Scheduler templates
After upgrading to the new Adaptive Server, perform the following steps to
upgrade templates and jobs created from Job Scheduler templates.
Note For the Adaptive Server version 15.0.2 release, there are several changes
that impact Job Scheduler templates. These changes make some templates
incompatible with earlier versions of Adaptive Server. These templates are
version 3.0 in the XML files.
v Upgrading Job Scheduler templates
1 Disable Job Scheduler before ugrading Job Scheduler templates.
2 Update any environment variables, scripts, or applications that refer to the
Job Scheduler directory path. The Job Scheduler directory has been
renamed and moved beneath the ASE-15_0 directory. New location is
$SYBASE/$SYBASE_ASE/jobscheduler.
Directories below jobscheduler remain the same.
3 If you have any of your own files in the old Job Scheduler directory, copy
them to the new 15.0.2 directory. If you are installing Adaptive Server over
the old server directories, the installer will have moved your files to the
new jobscheduler directory already.