Mails from stored procedure

Database
Enthusiast

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

4 REPLIES
Enthusiast

Re: Mails from stored procedure

Any suggestions  please

Enthusiast

Re: Mails from stored procedure

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.
Enthusiast

Re: Mails from stored procedure

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

Enthusiast

Re: Mails from stored procedure

please any one suggest me its urgent  for me .