Issue with Email attachment in Notification Activity
Posted: Mon May 14, 2012 1:45 pm
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
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