Special upgrade instructions  Using standby_access mode during migration

Release Bulletin Adaptive Server® Enterprise Version 12.5.2 for Mac OS X

Upgrading Job Scheduler

[CR #371574] Because of several changes made to sybmgmtdb, including the univarchar changes, you must run the installjsdb script anytime you upgrade Job Scheduler.

StepsUpgrading Job Scheduler

  1. Disable Job Scheduler before you upgrade Adaptive Sever:

    sp_configure "enable job scheduler", 0
    
  2. Upgrade Adaptive Server. See the installation guide for details on upgrading.

  3. Run the installjsdb script:

    isql –Usa –Psa_password –Sservername –i $SYBASE_ASE/scripts/installjsdb
    

    NoteYou must have the directory with the location of the isql executable ($SYBASE_OCS/bin) in your path.

    The installjsdb script looks for the sybmgmtdb database. The script updates Job Scheduler tables and stored procedures.

  4. Enable Job Scheduler:

    sp_configure "enable job scheduler", 1
    
  5. To start Job Scheduler, you can either restart the server or enter the following:

    use sybmgmtdb�
    go�
    sp_js_wakeup "start_js",1
    go�
    




Copyright © 2004. Sybase Inc. All rights reserved. Using standby_access mode during migration

View this release bulletin as PDF