Issue with Email attachment in Notification Activity

A forum for discussing DataStage<sup>®</sup> basics. If you're not sure where your question goes, start here.

Moderators: chulett, rschirm, roy

Post Reply
rashmi
Participant
Posts: 12
Joined: Tue Apr 18, 2006 5:06 am

Issue with Email attachment in Notification Activity

Post by rashmi »

Hi,

My DS job is loading to Netezza and it may or may not create a .nzbad file.
I wanted to attach this .nzbad file to email as attachment. Also there is no specific name for this file as it creates name dynamically.

NZCC_2012051411124910_25696_0.CDW_ETLPOC.nzbad

So In attachment option I have given below string:

/tmp/DS_Log_Bad_Files/*.CDW_ETLPOC.nzbad

But even if file is present, DS job says that :

Seq_Load_CBActives_Test_1..JobControl (DSSendMail): Cannot open attachment file '/tmp/DS_Log_Bad_Files/*.CDW_ETLPOC.nzbad'

File permissions:
-rw-r--r-- 1 dsadm dstage 14 May 14 12:41 NZCC_2012051411124910_25696_0.CDW_ETLPOC.nzbad

Please advice.
Thnaks,
Rashmi
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Doesn't support wildcards. You'll either need to 'look it up' and then pass it as a parameter each run or write your own email routine that can handle wildcards for the attachment.
-craig

"You can never have too many knives" -- Logan Nine Fingers
rashmi
Participant
Posts: 12
Joined: Tue Apr 18, 2006 5:06 am

Issue with Email attachment in Notification Activity

Post by rashmi »

Thank you for your reply.

Can you please elaborate on writing email routine?

Thanks,
Rashmi
Post Reply