Chapter 2: Configuring and Running Job Scheduler

Installing Job Scheduler manually

To run Job Scheduler, you must first run the Job Scheduler installation script and complete the following configuration steps.

Installing Job Scheduler

�Create a device called sybmgmtdev with a size of at least 50MB.
Run the installjsdb script:
```
isql –Usa –Psa_password –Sservername –i $SYBASE/$SYBASE_ASE/scripts/installjsdb
```
You must have the directory with the location of the isql executable ($SYBASE/$SYBASE_OCS/bin) in your path.

The installjsdb script looks for the sybmgmtdb database. If it exists, the script creates Job Scheduler tables and stored procedures. If it does not exist, the script looks for the sybmgmtdev device on which to create the sybmgmtdb database, the tables, and stored procedures.

If the installjsdb script finds neither a sybmgmtdev device nor a sybmgmtdb database, it creates a sybmgmtdb database on the master device. Sybase strongly recommends that you remove the sybmgmtdb database from the master device to prevent cluttering it and to make recovery easier in the case of a disk failure.
Create a directory services entry for the JS Agent using dscp, dsedit, or a text editor as appropriate for your specific directory services setup and operating system. Sybase suggests the name of “server name_JSAGENT”:
```
servername_JSAGENT�
    master tcp ether server_machine port_number
    query  tcp ether server_machine port_number
```
where:
- server_machine is the name of the machine on which the Job Scheduler Adaptive Server is installed.
- port_number is the port on which the JS Task communicates with the JS Agent.
  
  You must specify a port currently not in use.
See the System Administration Guide, Volume 1 for more information on directory services.
Use sp_addserver to create an entry in the sysservers table:
```
sp_addserver SYB_JSAGENT, null, <servername_JSAGENT>
```
See the ASE Reference Manual, Volume 2: Commands for more information on sp_addserver.

Enable Job Scheduler:

sp_configure “enable job scheduler”, 1

To start Job Scheduler, you can either restart the server or use the following commands:
```
use sybmgmtdb�
go�
sp_js_wakeup “start_js”,1
go�
```

View this book as PDF