Running the installjsdb Script

Follow these instructions if you installed Adaptive Server with Job Scheduler enabled.


  1. Stop Job Scheduler by issuing the following command from an isql session:
    use sybmgmtdb
    go
    sp_js_wakeup "stop_js", 1
    go
  2. Using isql, run the installjsdb script that is included with this release.
    isql -Usa -P<sa password> -S<servername> -n
         -i$SYBASE/$SYBASE_ASE/scripts/installjsdb
         -o<output file>
    Where:
    • -P is the password parameter
    • -S is servername parameter

    Save the output of this step to an operating system file.

  3. The installjsdb script looks for the sybmgmtdb database. The script updates Job Scheduler tables and stored procedures.
  4. Start Job Scheduler by issuing the following commands from an isql session:
    1> use sybmgmtdb
    2> go
    1> sp_js_wakeup "start_js", 1
    2> go


Created April 7, 2009. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com