Executing a Job from the Command Line

Previous Next

To execute a job from the command line, call runbatch.exe with the appropriate options:

runbatch.exe -database-type -database database-name {-ddfile | }

-app application-name -u user-name -pw password -exe "job( job-name, parameter=value, ... )"

 

Example

runbatch.exe –oracle –database PROD –ddfile –app MYAPP –u JOHN

–pw secrid –exe "job(EXP_PERSON,INS_AFTER=01-APR-2001)"

 

In this example:

•The application tables are stored in an Oracle database with name PROD.

•-ddfile –app MYAPP specifies that the application definitions for the MYAPP application are read from the "MYAPP.con" flat file, instead of from repository.

•The EXP_PERSON job is executed, with the job input parameter with name INS_AFTER set to 01-APR-2001.

Command line options for RUNBATCH.EXE

The table below lists all command line options available for RUNBATCH.EXE.

Option

Value

Purpose

-app

name

Specifies which application is run.

 

The required name is a string that is the name of the application.

-database

name

Specifies which database is to be used.

 

The required name is a known database connect string.

 

This parameter is mandatory if you use Informix, and optional if you use Sybase or Oracle.

-ddfile

 

Reads the repository from flat files instead of from repository.

 

If you use this option, also use the -app option to specify the application to look for.

-ddowner

name

Specifies that the application must be run on a repository owned by another user than the one under whose name you log in. To be used in combination with the -app option if you are NOT using the -ddfile option.

 

The required name is the name of the owner of the other repository.

 

Compare with -owner.

-exe

"job(

    job-name

,    parameter = value, ...

)"

Executes the specified job. Example:

-exe "job(EXP_PERSON,name=johnson)"

 

Job-name is required. The required number of parameter = value pairs (if any) depends on the information required by the job.

-logfile

filepath

Specifies the path and name of the log file, if you do not want the default filename:

 

job-nameHHMMSSLL.log

 

If you want the default filename but a different folder, set filepath to a folder name and end with the '\' symbol.

-mssql

 

Specifies that the application tables are in a Microsoft SQL Server RDBMS.

-odbc

 

Specifies that the application tables are in an ODBC enabled RDBMS.

-oledb

 

Specifies that connections are made via OLE DB; used by USoft to connect to Microsoft SQL Server.

-openclient

 

Specifies that application tables are in a Sybase OpenClient RDBMS.

-oracle

 

Specifies that the application tables are in the Oracle RDBMS.

-owner

name

The required name specifies the owner of the application tables is. You only need to use this if another user owns the tables.

 

Compare with -ddowner.

-password

password

Specifies your RDBMS password. Use this option if you want to log in automatically, in combination with the -u option.

-pw

password

Same as -password.

-silent

 

Suppresses the display of error messages on Windows.

Some exceptional messages (such as fatal errors during startup or initialization) will always be reported by means of message boxes, even when this –silent option has been used.

-solid

 

Specifies that the application tables are in a SOLID Server RDBMS.

-sybase

 

Specifies that the application tables are in the Sybase RDBMS.

-title "<name>"

 

Specifies the text displayed in the window's title bar. Note that this option may only be used on Windows platforms.

-u

name

Specifies your RDBMS username. Use this option if you want to log in automatically, in combination with the ‑pw option.

-user

name

Same as -u.

-wlogfile

 

Specifies that the existing log file (if any) is to be overwritten by a new log file, instead of being appended with new logging information.