Archives of the TeradataForum

Message Posted: Fri, 24 Jan 2003 @ 17:09:47 GMT


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Subj:		Re: How setup a e-mail notification from mload on failure of job

From:		Sajid Chida

Jason Fortenberry wrote:

1) One method I use is to read through the utility output with a Perl script to look for any error conditions and then act accordingly.

ok....that is fine..

If you also use any scheduling software for your jobs, they usually have the ability to send email or paging if a step fails.

I think perl will provide e-mailing facility.. after reading the mload output, if we found any error code, using perl we can send e-mail or pager notification... am i correct?

2) Use system command. Example: system "bteq D:/Systemstats/Canary_Select_Out.txt";

but here similarly if we do mload command like system

"mload err99.txt";

we are getting following error....

The system cannot find the file specified.

but if we run perl script from mload scripts directory... it's working fine... like system "mload err99.txt ";

do u have any idea?


	<Prev	Next>		<<First	<Prev	Next>	Last>>

Archives

2016		2007
2015		2006
2014		2005
2013		2004
2012		2003
2011		2002
2010		2001
2009		2000
2008		1999

2003 Indexes

Jan		Jul
Feb		Aug
Mar		Sep
Apr		Oct
May		Nov
Jun		Dec

Last Modified: 15 Jun 2023