SendMail by Using DataStage

nvkravi · Post by **nvkravi** » Fri Jun 20, 2003 3:39 am

Hello All,
I am new to this Tool. And I need to ask one query here. When I am running a Job or Job Sequence in DataStage5.2, So If this runs successful then I want to send a mail to One person and When It fails, to send another person. So, can you suggest me anyone how to do this? Here I am using both flat files and RDBMS in both Source and Target sides. Your Inputs would be Valuable.

ray.wurlod · Post by **ray.wurlod** » Fri Jun 20, 2003 5:36 pm

Create a job sequence with a Job Activity to run your job. Add two Notification Activities, with links from the Job Activity to each. Adjust the triggers in the Job Activity to "Run OK" for the one link, and "Otherwise" for the second link. In the Notification Activities set up the email parameters you need to send the reports.

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518