Page 1 of 1

Mailing Warnings Job Server

Posted: Fri Jan 13, 2012 8:14 am
by lote11
Hi masters,
Does anyone knows how to mail warnings from a server Job. For example my server job finish with warnings because the stored procedure that executes fails. When i go to the director it shows the warning that the stored procedure gives, i want to mail the event detail that the director shows about this job server.

Thanks
Juan

Posted: Fri Jan 13, 2012 9:06 am
by chulett
Simplest way? Run the job in a Sequence job and link it on failure to an Email Notification stage with the option enabled that includes job status.

Posted: Fri Jan 13, 2012 11:33 am
by lote11
The problem with that is that i get this error : The following tokens in the 'dssendmail_template.txt' file have not been set in the call to DSSendMail: %from%

Posted: Fri Jan 13, 2012 2:59 pm
by chulett
It does log some informational messages similar to that that can be ignored but are you saying you actually get an error and the Sequence job fails? Have you put something in the 'From' field of the Email Notification activity?

I'd also be curious if this is the first time you've tried to email anything or if it works in other Sequence jobs but not in this one.

dsjob command

Posted: Sat Jan 14, 2012 11:02 pm
by ketfos
Hi,
you can read the job log with dsjob command
and pass project name, job name with BASIC option.

ketfos

Posted: Wed Jan 18, 2012 12:02 am
by mgsteiner
lote11 wrote:The problem with that is that i get this error : The following tokens in the 'dssendmail_template.txt' file have not been set in the call to DSSendMail: %from%
Make sure you have configure the SMTP correctly. Have you done that?, Have you tested it?