I'm aware that each job notification can be customized but I'm working with over 1,200 jobs. I need to be able to dump the email body text into a variable and connect it to the appropriate job using the %WOB._fullname method.
if(WOB._fullname.search('Data_Quality') >=0 APPL.Email_Body = 'This is a Data Quality Notification.';
In this situation WOB._fullname returns a random job name from within the application. So the text being searched has nothing to do with the current job. Which then causes the wrong text to be returned in the variable %APPL.Email_Body.
As per DE programming guide, the WOB level variables will return the following value.
Specifies the name of the job, excluding the qualifier. The name resolves in uppercase, for example, PAYJOB1.
Specifies the full name of the job, including the qualifier. The name resolves in uppercase, for example, PAYJOB1.RUN1. If the qualifier is not specified, the %WOB._fullname variable resolves to the job name.
Do you have any thing else defined in the 'Qualifier' field of the job?
Good Morning Nitin Pande,
I'm aware of what the documentation says. The way the software actually works is different, hence my question. I'm very happy to illustrate the issue. It is entirely possible that I'm not utilizing the software correctly. Regardless, I'd like to be able to use the software as it was intended. I'd also like to understand why I'm seeing this behavior from a fairly simple variable call.
I ran a quick test and I could see that the application ran (and simulated) the variables correctly. Here is an output of simulation, the "Arguments to pass" field had /tmp/%WOB._fullname in the job. It correctly returned the fullname to DATE.1.
Name: DATEQualifier: 1Job Type: UNIXPredecessors: LS.1Run: DAILYAnticipated Start Time: ******************Anticipated End Time: xxxxxxxxxxxxxxxxExecution time: 0 minsLife time: 1 min, 54 secsAuto-Resubmit failed job: RetryCount(0) RetryInterval(0) Agent name: AGENTExecute a command: /bin/touchArguments to pass: /tmp/DATE.1User ID: root
I am using R12 Sp2. Can you tell me what is the version of dSeries you are using?
I would like to see how you are calling these WOB level variables.
Thanks and regards,