Using functions in Parameter values

Parameter values can be fixed values, but in RunMyJobs a lot of functions are available.

Read a value from the System_Variables table


The System_Variables table can easily be used as key-value-pair table. It is very simple to retrieve a value from this table as default value for a parameter. Below is an example to the value of the ENVIRONMENT-key (key names are case sensitive).

       =Variable.getString('ENVIRONMENT')

Reference to a JobId of a Job in the JobChain


Sometimes it can be necessary to lookup a JobId of a previous job in the Chain. An example is to retrieve one of its JobFiles (e.g. generated CSV-file). Use the JobChainParameters.getJobId to get the JobId. The function takes 1 parameter which is composed of the Step-name and the relative job. To get the JobId of the 1ste job in the step Generate_CSV, use the following expression

      =JobChainParameters.getJobId('Generate_CSV, Job 1')

Time-functions in a parameter expression


Sometimes it can be necessary to use a time function. RunMyJobs has a lot of functions to modify or calculate dates. Below an example to set the current time minus 1 hour:

      =Time.expressionNow('subtract 1 hour')