Previous Next

Executes a specific job. Consider calling the job's job method instead.

Returns a string containing an XML document. The format of this document is the same as the output of the XML.SqlExport method. The contents are all records from the output parameter set table. If the job has an output parameter set, then the output XML contains exactly one output record with one column (just like XML.SqlExport). If the job does not have an output parameter set, the output column is NULL.


Parameters (if any) are passed in the SELECT output list. The value is a SQL column expression, and the parameter is a column alias. A column alias that contains a special symbol such as a space ( ) or a hyphen must be surrounded by double quotes to avoid misinterpretation of the special symbol by the SQL parser. Double-quoting of column aliases is always legal.

INVOKE    BatchRunner.RunJob WITH

SELECT    job-name

,         value    parameter

You can use function call syntax as an alternative for INVOKE. In this syntax, SELECT replaces INVOKE and the method name is followed by parentheses which surround parameters (if any are passed):

SELECT BatchRunner.RunJob(
,      ...

The required job-name must be the first input parameter. Other parameters (if any) are passed by name. They may be passed in any order.

Example 1

INVOKE    BatchRunner.RunJob 
SELECT    'MyFirstJob'

Example 2

SELECT    BatchRunner.RunJob('MyJob', 'True' "-quiet", contract_id "contract_id")

NOTE: In this example, -quiet is a predefined parameter.

Example 3

INVOKE    BatchRunner.RunJob
SELECT    'MySecondJob'
,          'true'                          "-quiet"
,          'c:\batch_output\StoreOrder'    "-STORE_ORDER:data_directory"
,          '#'                             "-nvl"
,          c.contract_id                   "contract_id"
,          56                              "department_id"
FROM      contracts c

NOTE: In this example, -quiet, -data_directory and -nvl are predefined parameters.


See also

Predefined parameters for Batchrunner calls