Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sending email from .bat file
Try BLAT for Windows NT. You can find it on the internet. Where ??????
Greetings,
Frans Trip
Oracle DBA
Vertis B.V.
The Netherlands
sankara.subramanian_at_coats.com wrote:
> Hello people,
> I have a strange requirement at my work. I have to send an email from
> .bat file on an nt operating system whenever an oracle job fails
> (sqlplus etc).. How can I do it. I've done the hard part of exiting out
> of sqlsession whenever there is an error using the exit code.
>
> Now I have the exit code value stored in the local variable in the bat
> file. (0 for failure 1 for success). Now I want to email the users based
> on the value I get in my variable.
> for example, if a sqlplus session fails, then the exit code will have
> athe value of 0, in this case I want to send a email to me and to other
> people using some kind of mail function.
>
> I have done this unix But unfortunately my company moved away from UNix
> (to NT :(.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Mon Jun 21 1999 - 03:35:39 CDT