Special upgrade instructions  Upgrade support for Adaptive Server version 12.5.3a

Release Bulletin Adaptive Server® Enterprise Version 12.5.3a for IBM AIX

Upgrading Job Scheduler

[CR #371574] If you are upgrading from Adaptive Server versions earlier than 12.5.2, 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 © 2005. Sybase Inc. All rights reserved. Upgrade support for Adaptive Server version 12.5.3a

View this release bulletin as PDF