Re: SQL 2000 Maintenance Plan Email Notifications

See my reply in the other ng.

--
Andrew J. Kelly SQL MVP


"Brad Baker" <brad@xxxxxxxxxxxxx> wrote in message
news:ezXylhJiFHA.2156@xxxxxxxxxxxxxxxxxxxxxxx
> We are running SQL 2000 SP4 on Windows 2003 Server Enterprise in a 4 node
> clustered environment. We need some way to receive notifications when our
> maintenance plan jobs fail. I've been investigating and have found the
> following approaches:
>
>
>
> 1) Using SQL Mail and a MAPI Client such as Microsoft Outlook
> (http://support.microsoft.com/default.aspx?scid=kb;en-us;870675)
>
> 2) Using SQL Server SMTP Mail XP (http://www.sqldev.net/xp/xpsmtp.htm)
>
> 3) Using CDOsys
> (http://www.sql-server-performance.com/dh_sending_sql_notifications_CDOSYS.asp)
>
>
>
> The problem is:
>
>
>
> Option 1 (Using SQL mail): Seems to have about half a dozen stipulations
> on it. I.E. You have to be running X version of outlook, leave the mail
> client open, frequently locks up, won't work in a clustered environment,
> won't work with a normal SMTP server.
>
>
>
> Option 2: We just can't seem to get it to work at all. It also doesn't
> seem to be cluster friendly.
>
>
>
> Option 3: Works mostly, but takes a lot of time to setup and the
> notifications can break if you start editing your maintenance plans.
>
>
>
> It would seem to me that there must be some way to setup SQL email
> notifications for maintenance plans that works and is reliable in a
> cluster environment. Does anyone have any suggestions or pointers? What am
> I missing?
>
>
>
> Thank You,
>
> Brad Baker
>
>


.

Relevant Pages

  • Re: SQL 2000 - Databases getting backed up multiple times
    ... I called ARCServe and they agreed that we don't need both the native SQL ... Maintenance Plans backing up our logs and databases in addition to ARCServe. ...
    (microsoft.public.sqlserver.server)
  • Re: Logging details in SQL Server 2005 Maintenance Plan
    ... Andrew J. Kelly SQL MVP ... Does not occur when you run the Maint Plan vanilla ... >> In setting up maintenance plans in SQL 2005, I am unable to get the ... >> log file? ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL 2005 deleting old backups
    ... There were several issues with the maintenance plans and SP2. ... Loading SP2 was not enough, you need to load some hotfixes etc to fix all the crap that SP2 broke. ... A client of ours has SQL Server 2005 with the latest service pack. ... the subplans in the database maintenance plans is to delete old backup files ...
    (microsoft.public.sqlserver.setup)
  • Re: Missing User groups in SQL 2005 Cluster install
    ... installer. ... Senior Database Administrator ... Microsoft SQL Server MVP ... clustered environment but not in the clustered environment and that the ...
    (microsoft.public.sqlserver.setup)
  • SQL and MSMQ
    ... We have a system running on SQL 2000. ... Client systems need to access the data (via webservice). ... send notifications to the clients that they need to go to the ...
    (microsoft.public.sqlserver.programming)