e-mail Notifications

Visit Teradata.com

Home

Guidelines

Member List

Welcome Guest ( Login | Register )

This online forum is for user-to-user discussions of Teradata products, and is not an official customer support channel for Teradata. If you require direct assistance, please contact Teradata support.

e-mail Notifications

Rate Topic

Display Mode

Topic Options

Author

Message

ilyas

Posted 7/17/2006 11:00:57 AM

Junior Member

Group: Forum Members
Last Login: 9/8/2006 1:20:00 PM
Posts: 10, Visits: 1

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

Ilyas

Post #4634

trying_to_learn

Posted 8/7/2006 3:37:14 PM

Junior Member

Group: Forum Members
Last Login: 12/13/2006 3:52:00 PM
Posts: 14, Visits: 1

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

Regards

S S

Post #4828

sparan

Posted 8/16/2006 2:07:22 PM

Junior Member

Group: Forum Members
Last Login: 3/27/2008 11:31:18 AM
Posts: 19, Visits: 25

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

Post #4912

« Prev Topic | Next Topic »

Reading This Topic

Active Users: 0 ( 0 guests, 0 members, 0 anonymous members )

No members currently viewing this topic.

All times are GMT -5:00, Time now is 10:11am