sending file my email
Moderators: chulett, rschirm, roy
sending file my email
hi,
i have an execl file which i load then i send to client for test data , can i automate that as soon as the job complete it automtically get emailed to them , i mean any automatic process i can do.
thanks
bobby
i have an execl file which i load then i send to client for test data , can i automate that as soon as the job complete it automtically get emailed to them , i mean any automatic process i can do.
thanks
bobby
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
Re: sending file my email
bobby wrote:hi,
i have an execl file which i load then i send to client for test data , can i automate that as soon as the job complete it automtically get emailed to them , i mean any automatic process i can do.
thanks
bobby
Once the job for load is complete you can use the after routine to execute a shell script to mail the file to the specified person. use the MailX command for sending the mail with an attachment.
If you are sending a mail to just let them know the loaded file is there, then Use Notification activity.
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
bobby wrote:Hi,
I want to send that file so u mean routine activity i should use , can u advise wht routine name as i have not seen any mail in there
thanks
bobby
if you want to send the file as an attachement, call the shell script from the routine activity or from after subroutine.
In the shellscript write the MailX command
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
vcannadevula wrote:bobby wrote:Hi,
I want to send that file so u mean routine activity i should use , can u advise wht routine name as i have not seen any mail in there
thanks
bobby
if you want to send the file as an attachement, call the shell script from the routine activity or from after subroutine.
In the shellscript write the MailX command
Use the ExecSH
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
hi
i did this ,its not working i went to EXECSH and in input i wrote
$mail bobby@express.com</datastage01/nin/Act_Sub.csv
thanks
bobby
i did this ,its not working i went to EXECSH and in input i wrote
$mail bobby@express.com</datastage01/nin/Act_Sub.csv
thanks
bobby
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
bobby wrote:hi
i did this ,its not working i went to EXECSH and in input i wrote
$mail bobby@express.com</datastage01/nin/Act_Sub.csv
thanks
bobby
mailx -s "ur subject" -c 'any CC address' 'TO address' < /tmp/email.msg
Use the above command. The last part is the path of the file you want to attach and email.msg is the file being attached here in this example which is located in /tmp folder.
this command give me whole body of excel file i want attachment
$mail bobby@express.com</datastage01/nin/Act_Sub.csv
$mail bobby@express.com</datastage01/nin/Act_Sub.csv
-
- Charter Member
- Posts: 143
- Joined: Thu Nov 04, 2004 6:53 am
bobby wrote:this command give me whole body of excel file i want attachment
$mail bobby@express.com</datastage01/nin/Act_Sub.csv
cat /datastage01/nin/Act_Sub.csv >> /tmp/email.msg
mailx -s "$SUBJECT" -c $CCADDRESS $TOADDRESS < /tmp/email.msg