Page 1 of 1

Sequence job

Posted: Fri May 09, 2008 3:34 am
by ketanshah123
Hi
I want to send a mail notification if any job in Job Actvity in sequence ends with warnings. But I dont wants to use mail notification activity stage.So how can I do it ?Is it possible on Cstom trigger type in Job activity stage through some expression...
If yes then how can I check whether job ends with warning and then how can I send the mail

Thanx in advance

Posted: Fri May 09, 2008 3:47 am
by tsn
Use job status to find out the job completed with warnings or not. then you use routine (DSSendMailTester) to send the mail.

Posted: Fri May 09, 2008 6:18 am
by ketanshah123
can you plz provide me the example of DSSendMailTester as I am getting syntax error again and again ...

Posted: Fri May 09, 2008 6:50 am
by ArndW
how about telling us what your syntax error is, that might be easier.

Posted: Fri May 09, 2008 6:57 am
by ketanshah123
just getting message general syntax error ...

Posted: Fri May 09, 2008 7:18 am
by chulett
:? Why the heck not just simply use the Notification Activity stage? The 'Tester' routine is just that - for testing.

Posted: Fri May 09, 2008 4:05 pm
by ray.wurlod
DSSendMailTester is provided precisely so that you can inspect the code and thereby learn the correct syntax for invoking DSSendMail().

Please do so.

Posted: Mon May 12, 2008 1:40 am
by tsn
have you figured it out?