Job Updater

The Job Updater (JOBUPD) page can be used to set up data for the Job Parameter Updater process. The Job Parameters Updater process updates batch parameter values for jobs run as part of the nightly cycle. This helps in reducing the manual effort in setting up the jobs for execution. The data on this table is a set of table row columns to be updated for specific jobs, which run regularly on a schedule.

Field Name	Description
Catalog Id	The Catalog ID of the batch job whose batch parameters need to be updated by the Job Parameter Updater process.
Job Name	The name of the batch job whose batch parameters need to be updated as part of the Job Parameter Updater run.
Table Name	The name of the table whose specific cell needs to be updated. Typically, this is BS_CATALOG_PARAM although it can even update any other reference table, if the where-clause for the row to be updated is defined.
Parameter Name	If the table name is BS_CATALOG_PARAM then Parameter Name is used as name of the batch catalog parameter to be updated. In case of any other table name, this is the name of the column within that table which needs to be updated.
Parameter Value	Parameter Value keeps the reference to the actual value that is defined in the Job Updater Parameters table. The value is resolved at job execution time based on the expression defined for that value.
Frequency	This drop-down field is currently used to perform sort order for the updates to the table rows. Valid values are Daily, Weekly, Monthly, and Specific.
Where Clause	This field is used when table name is anything other than BS_CATALOG_PARAM. It is an expression that follows a specific syntax. This expression is resolved at runtime to form the where-clause while updating table values. If this field is left blank, then all rows from the mentioned table name will be updated with specified value. Example: `USER_ID = '${USER_ID}' AND EMP_CD = ${EMP_CD}` The where-clause should always be enclosed in the ` (ASCII backquote) character. String type column values should always be enclosed in ' (ASCII single quote) characters.
Active Flag	The Job Parameters Updater job will pick up only those records from this table that have Active Flag set to true or checked.