Sequencer Attachment Problem

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
pnchowdary
Participant
Posts: 232
Joined: Sat May 07, 2005 2:49 pm
Location: USA

Sequencer Attachment Problem

Post by pnchowdary »

Hi Guys,

I have a simple sequencer job that runs two jobs one after another and then sends an email after completion of the jobs. I tried to attach the job status of the two jobs in the email. When I get the email, I am getting an warning as shown below in the email. I selected the job status parameter using the External Parameter Helper.

The job status attachment parameters used are shown below

#CPS01_STOCK_TR.$JobStatus##CPS01_SCHED_LINES.$JobStatus#

WARNING - MISSING ATTACHMENT: Cannot open attachment file '22'

I have even tried seperating the above parameters using a comma and enclosing each parameter in single quotes as instructed in the manual. In this case, I am getting the below warning.

WARNING - MISSING ATTACHMENT: Cannot open attachment file ''2''
WARNING - MISSING ATTACHMENT: Cannot open attachment file ''2''



Job Design

Code: Select all

Job1 ---> Job2 ----> Send Email
Can anyone tell me why I am getting this error?

Thank you very much.

Naveen
ketfos
Participant
Posts: 562
Joined: Mon May 03, 2004 8:58 pm
Location: san francisco
Contact:

Post by ketfos »

Hi,
One of the jobs has reference to this file ZZ.
Look at individual jobs for this file.
Run each job seperately to see if you get this warning message.

Also see in the sequencer, where this file ZZ is refered to.

Ketfos
Sainath.Srinivasan
Participant
Posts: 3337
Joined: Mon Jan 17, 2005 4:49 am
Location: United Kingdom

Post by Sainath.Srinivasan »

I think both jobs returned warning - status 2 - and hence the param combination returned '22'.

What file do you want to attach and what is the purpose of that file?
pnchowdary
Participant
Posts: 232
Joined: Sat May 07, 2005 2:49 pm
Location: USA

Post by pnchowdary »

Sorry Guys, its my mistake. I was trying to attach the complete job logs of the individual jobs in my email as attachments. I just now realized that JobStatus parameter returns the return code and not the job log. If I want to include the job logs of the individual jobs as attachments instead of inline text in the email ( i know this can be achieved by checking the check box include job status in email option), How would I achieve that?. Any help would really be appreciated.

Thanks,
Naveen
Post Reply