e-mail Notifications

UDA
Enthusiast

e-mail Notifications

I have created some BTEQ scripts. I want to know that if my scripts abort, is it possible for me to send some e-mails through some teradata utility as in oracle we do. Thanks
2 REPLIES
Enthusiast

Re: e-mail Notifications

I do not know whether it will work if you put this statement in BTEQ script, but it works if you write a k shell and call your BTEQ script and at the end write this statement, it will send you an mail as soon as it finishes the script

mail -s "your message" yourmail_id
Enthusiast

Re: e-mail Notifications

you can use .os to generate email from bteq script. Basically it will execute operating system commands in bteq mode.

here is an example

sql1;
sql2;

.os mailx -s "subject" email_address < file_name as a message

-- Sparan