sp_jsconfigure

Syntax

sp_jsconfigure [option [, value]]

Parameters

option – option is one of:
- interfaces path – path to the interface file
- errorlog – path to the errorlog
- help – displays the syntax for sp_jsconfigure
value – Specifies the value to which you are setting option.

Examples

Example 1 – Displays the sp_jsconfigure syntax:

sp_jsconfigure "help"
Usage: sp_jsconfigure [option [, value]]
        where option : 'interfaces path', ' errorlog ', 'help'
              value  : value to set for the 'option'

Example 2 – Sets the path to the interfaces file:
```
sp_jsconfigure 'interfaces path', "/SAP_ASE/data"
```
Example 3 – Sets the path to the errorlog:
```
1> sp_jsconfigure "errorlog", "/SAP_ASE/data/js.log"
```

Example 4 – Displays the values to which you have set sp_jsconfigure:

sp_jsconfigure
Parameter Name                   Config Value                                                                                               
 -------------------------------- ---------------------------------------------------------------------------------------------------------- 
 interfaces path                  /SAP_ASE/data                                                      
 errorlog                         /SAP_ASE/data/js.log

Usage

Use the installjsdb script to install sp_jsconfigure (located in $SYBASE/$SYBASE_ASE/scripts).
You must restart JS Agent for the configuration changes to take affect.
sp_jsconfigure uses default values if you do not supply values for interfaces path or errorlog.
Job Scheduler does not start if you include paths for the interfaces path or errorlog options that do no exist.
interfaces path must include an interfaces file with an entry for the Job Scheduler host and target server on which the scheduled job is executed (the target and host server can be the same machine).

Permissions

You must have the js_admin_role to execute sp_jsconfigure.