Downgrading Job Scheduler

If you are downgrading to Adaptive Server versions 15.5, run installjsdb script from the earlier version.

  1. Disable Job Scheduler:
    1> sp_configure "enable job scheduler", 0
    2> go
    1> sybmgmtdb..sp_sjobcontrol @name=NULL, @option="stop_js"
    2> go
  2. Follow the downgrade steps for your platform.
  3. After downgrading, enter this command from the earlier version of Adaptive Server:
    isql –Usa –Psa_password –Sservername
    –i%SYBASE%\%SYBASE_ASE%\scripts\installjsdb
    Note: The directory with the isql executable (%SYBASE%\%SYBASE_OCS%\bin) must be in your path.
  4. Enable Job Scheduler:
    sp_configure "enable job scheduler", 1
  5. To start Job Scheduler, either restart the server, or enter:
    1> use sybmgmtdb
    2> go
    1> sp_sjobcontrol @name=NULL, @option="start_js"
    2> go
Related tasks
Downgrading from Adaptive Server 15.7 SP100