DSSendMail

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
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

DSSendMail

Post by sjordery »

I want to use DSSendMail as a post job routine. I am unable to figure out how to give the parameters for the DSSendMail job. Is there a syntax? I am copying the DsDirector report for a run:

JenaTest..AfterJob (DSSendMail): Parameter 1 (''smtp.abcd.com','subrata.jena@abc.com','rana.sinharay@abc.com','testing','','source'') does not start with a keyword

What keyword is expected here?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

All of the actual parameter names are missing from your string. And you've got an odd mixture of quotes there. Open up the DSSendMail routine by double-clicking on it in the Administrator and check the Long Description for details on exactly how to call this routine.
-craig

"You can never have too many knives" -- Logan Nine Fingers
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

okay
I got the out put.
one issue regarding this
I also wants to attach a file in the DSSendmail post job routine.
I have set the parameter as mentioned below.

From:jordery@abcd.com\nTo:pqr@abcd.com\nServer:smtp.ss.com\nAttach /usr/ctg/dbacess.txt

Here the attached file dbacess.txt is not being transferred in the mail only a blank mail is transferred.
Can you suggest me what is the problem?
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

No colon after "Attach"?
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

ok ray,

I gave the colon after attach still the attachment nt getting transferred.
The syntax is like this

From:jordery@abcd.com\nTo:pqr@abcd.com\nServer:smtp.ss.com\nAttach:/usr/ctg/dbacess.txt

any suggestions??
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Take a look at the demonstration routine DSSendMailTesterAttachment. Try it with your values. If it works, diagnose the differences. If it doesn't work, read the error messages (double click the Result cell in the test grid) carefully. Carefully.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
sjordery
Premium Member
Premium Member
Posts: 202
Joined: Thu Jun 08, 2006 5:58 am

Post by sjordery »

Under the before-after subroutines following 4 catagories are coming
1-DSJobReport
2-DSSenmail
3-DSWaitforfile
4-ExecSH
5-ExecSHSilent
6-ExexTCL

In the designer also we can choose any of the above only.
Then how to choose the DSSendMailTesterAttachment in the after subroutine.

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

Post by chulett »

No-one is suggesting you use it in a job. Open it via the Manager. Look at the code there. Run it by 'Test'ing it in the Manager.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Look in the Built-In\Utilities category.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
fspdxn
Participant
Posts: 2
Joined: Thu Oct 13, 2005 10:52 pm

Post by fspdxn »

I had the same issue and also tested the DSSendMailAttachmentTester routine (which works and the file was attached). I then tried adding a Body after the Attach and it worked. Guessing here, but the attachment wont be there unless you have a body definition.
Post Reply