I am a normal Teradata user without administrative access.
Can I write something to make Teradata send email like SQL server's xp_sendmail? If yes how do I create a macro or stored procedure or anything else to auto send out an email directly from the Teradata Server ONLY when data exists in my specific query result?
Example: I would like to receive an automatic real-time email whenever a car has been left in the parking garage for over 2 hours. (When the car enters the lot an IN_Time is generated and an OUT_Time when it exits. If OUT_Time is null and CurrentTIME - IN_Time is greater than 120 minutes send email to xxx@xxx.com)
If teradata cannot send out the email, is there a way to create a webpage that will run the query every 15 minutes and send an email only when data exists in the query result?
I posted the question here but have not had any replies yet.
Can I write something to make Teradata send email like SQL server's xp_sendmail? If yes how do I create a macro or stored procedure or anything else to auto send out an email directly from the Teradata Server ONLY when data exists in my specific query result?
Example: I would like to receive an automatic real-time email whenever a car has been left in the parking garage for over 2 hours. (When the car enters the lot an IN_Time is generated and an OUT_Time when it exits. If OUT_Time is null and CurrentTIME - IN_Time is greater than 120 minutes send email to xxx@xxx.com)
If teradata cannot send out the email, is there a way to create a webpage that will run the query every 15 minutes and send an email only when data exists in the query result?
I posted the question here but have not had any replies yet.