SCHEDULING SQL QUERIES IN ALERT SETUP- DELIVERY SETTINGS

Viewpoint
Enthusiast

SCHEDULING SQL QUERIES IN ALERT SETUP- DELIVERY SETTINGS

Hi Team,

I am trying to execute a Macro in the SQL tab (Delivery Settings>SQL Queries>SQL ).

The macro is selecting some table information  and generating ALTER TABLE statements, can you guide me how can i get ALTER SQL statements through mail.

1 REPLY
Teradata Employee

Re: SCHEDULING SQL QUERIES IN ALERT SETUP- DELIVERY SETTINGS

Not sure I understand your question. You can get notifed by e-mail for SQL Queries timeout / abort actions. this is done through Alert Setup -> Alert Exceptions. If you are suggesting getting return information from a SQL Statement to be emailed to you, you can't do that.