Re: email notification on job status

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: inquisite (inquisite_at_discussions.microsoft.com)
Date: 01/31/05 

Date: Mon, 31 Jan 2005 10:16:25 -0800

SMTP solution is not available. That is why I wanted to send an email through
some script running on the server.

"Andrea Montanari" wrote:

> hi,
> inquisite wrote:
> > In MSDE, since there is no sql mail, I am thinking of doing the
> > following:
> >
> > 1. write a shell script which will query the sysjobhistory table to
> > determine if any job failed. If so, then an email about the failure
> > is sent out.
> >
> > Question: What should my sql command and my mail command look like. I
> > dont have much experience in shell scripting or am not very familiar
> > with MSDB database either.
>
> if an SMPT solution is viable, I'd resort on xp_smpt extended stored
> procedure provided at http://sqldev.net/xp/xpsmtp.htm
> you can then code your task's step to send a mail on success or failure..
> SQL Server MVP Tibor Karaszi presents and describes such a feature at
> http://www.karaszi.com/sqlserver/info_no_mapi.asp
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
> DbaMgr2k ver 0.10.0 - DbaMgr ver 0.56.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> --------- remove DMO to reply
>
>
>

Relevant Pages

  • i had a doubt in shell scripting.. can any one clear it?
    ... we had a script running to show status of applications running on our ... server.. ... file1 consists of list of application servers. ...
    (comp.unix.shell)
  • Re: How to send email when file changes?
    ... way to keep a script running and receive event notifications from a ... You would also have to record info about the files or the script would just ... server changes. ...
    (microsoft.public.windows.server.scripting)
  • Re: PHP-mySQL connection being refused
    ... I have a script running that accesses a mysql database on a shared ... On my ISP's server status page, ... RaQ08 is experiencing problems with its backnet connection to ...
    (comp.lang.php)
  • PHP-mySQL connection being refused
    ... I have a script running that accesses a mysql database on a shared server. ...
    (comp.lang.php)
  • Re: email notification on job status
    ... If an SMTP server is not available then how were you planing to send email? ... Jim ... > SMTP solution is not available. ...
    (microsoft.public.sqlserver.msde)