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, ... )"


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.






Specifies which application is run.


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



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.



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.



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.




,    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.



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




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



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



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



Specifies that the application tables are in the Oracle RDBMS.



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.



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



Same as -password.



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.

-title "<name>"


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



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



Same as -u.



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.