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