All Forums Database
sunny.j 90 posts Joined 10/10
28 Sep 2011
Mails from stored procedure

Hi,

 

 

I have created a Stored procedure to build the Sql Dynamically  and  will execute with in the procedure .

 

when there is an error in preparing the Sql query dynamically i need to send a mail to DBA team mentioning the error .

 

can any one help me how to send mails with in the stored procedure .

 

Thanks & Regards

Sunny.J

sunny.j 90 posts Joined 10/10
28 Sep 2011

Any suggestions  please

AbeK 24 posts Joined 08/09
28 Sep 2011

Depending on whether you use Teradata Manager or Viewpoint, if you have Smtp configured to send emails then you could leverage the AlertRequest table to submit the notifications that you want to be sent via email.

sunny.j 90 posts Joined 10/10
28 Sep 2011

I want to send mails from a stored procedure . any suggestion about that .

sunny.j 90 posts Joined 10/10
29 Sep 2011

please any one suggest me its urgent  for me .

You must sign in to leave a comment.