ATTRIBUTES ( VARCHAR UserName = @UsrID, VARCHAR UserPassword = @Pwd, VARCHAR Tdpid = @Tdpid );
The job variable reference is composed of the @ symbol, followed by a unique identifier for the variable. You can use the attribute name or any other identifier.
When a job script is submitted for execution, the first thing that happens is that the characterstring value of each job variable replaces all occurrences of that job variable in the script text, just as if the value had been part of the original script text at those places. Only then is the script compiled.
You can also reference a job variable for an attribute value in the APPLY statement.
Attribute Value Processing Order
Object attribute values can be assigned at several locations within the job script.
- DEFINE OPERATOR
- As part of an APPLY TO...SELECT FROM statement