Upgrading Job Scheduler

After upgrading to a new Adaptive Server, upgrade Job Scheduler.

Note: You must have $SYBASE/$SYBASE_OCS/bin directory in $PATH so the isql executable is accessible. Use isql to perform all the steps in this task.

Copy the directory services entry for JSAGENT (or jsagent) from the old server to the new server.
Make sure the new server is running.

Stop the Job Scheduler:

1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
2> go

Ensure that at least 9000 locks are configured. If the number of locks on the server is fewer than 9000, increase it:
```
1> sp_configure "number of locks", 9000
2> go
```

Upgrade the internal Job Scheduler SQL code using:

1> use sybmgmtdb
2> go
1> dbcc upgrade_object
2> go

Restart Adaptive Server.
(Optional) Add more log space. Some 64-bit platforms require additional space for the sybmgmtdb log:
```
1> use master
2> go
1> alter database sybmgmtdb LOG on sybmgmtdev=20
2> go
```
To upgrade sybmgmtdb, run the installjsdb script that is included and save the output to a file:
```
isql -Usa -Psa_password -Sservername -n -i%SYBASE%\%SYBASE_ASE%\scripts\installjsdb -ooutput_file
```
Note: When upgrading from Adaptive Server version 12.5.x to 15.5 and later, increase the size of sybmgmtdb from 50MB to at least 160MB. sybmgmtdb mus thave free log space of at least 60MB.
Enable Job Scheduler to start when Adaptive Server starts:
```
sp_configure "enable job scheduler", 1
```

To start Job Scheduler from isql, enter:

sybmgmtdb..sp_sjobcontrol @name=NULL, @option="start_js"
go