Re: Emailing SQL 2000 maintenance report via SMTP?

From: Keith Kratochvil (sqlguy.back2u_at_comcast.net)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 07:35:26 -0600

First of all, can I suggest that you not use the maintenance plan for
backups? You can create jobs within the SQL Server Agent that will backup
your databases. Books Online (within the SQL Server program group) contains
T-SQL examples of backup scripts. If you are so inclined you can also
create jobs that perform the appropriate maintenance tasks (such as checkdb,
checkcatalog, updateusage, update statistics).

You could use XPSMTP http://sqldev.net/xp/xpsmtp.htm to send email alerts. 

-- 
Keith
"Astra" <info@noemail.com> wrote in message
news:uXPyFCzGFHA.2452@TK2MSFTNGP10.phx.gbl...
> Hi All
>
> As per my post in microsoft.... server NG, I keep getting a problem where
my
> DB maintenance plan just stops doing what it should, which in turn means
> that if I don't paranoid-ly check it each day I get the scenario (like
> today) where I find my backups haven't been working for a month!!!
>
> What I would like to do is email the maintenance plan to a designated
email
> address so that I can easily see every morning whether or not it has
worked.
>
> I know the old SQL 6.5 used to provide SQL Mail, but this links in with MS
> Exchange Server and I don't use this.  I don't even have it running on my
> SBS 2000 Server.
>
> Is there anyway in SQL 2000 that I can get it to email the report via
SMTP?
>
> I'm familiar with JMail and it's COM/DLL is installed on my server if I
> could use that.
>
> Thanks  Robbie
>
>

Relevant Pages

  • SQL 2005 Database Mail Fails - HERES HELP - Maintenance Plan, SMTP
    ... Here is how I got SQL 2005 Database Mail to work .... ... Send email from Database Maintenance Plan. ... Computer B = Windowns 2003 Server with a named instance of SQL Server ...
    (microsoft.public.sqlserver.setup)
  • Re: Backup software for SBS2003 Standard
    ... I configured my test server with Windows Server 2003 and SCE, which runs on a SQL or MSDE database. ... As you say, I'd continue to do the online Exchange backups, maybe to file so they're included in the SP backups. ... For databases I care about, I do Enterprise Manager backups to file a few times a day, and those get included in the SP backups as well. ...
    (microsoft.public.windows.server.sbs)
  • Re: MSDE OSQL Shutdown
    ... dann den Server herunterfährst könnte genau in dem Moment die Aktion ... Aus Gründen der Datenkonsistenz sollten Datenbanken niemals Offline ... weil alle Backups dazwischen unbrauchbar waren;-) ... Datenbank Verzeichnis des SQL Servers dafür vom Dateibackup aus. ...
    (microsoft.public.de.sqlserver)
  • Re: SQLVDI - Fixed
    ... Fixed it on my problem server. ... the app they use filed on SQL 2005, so I downgraded to SQL 2000 and then ... installed Share Point which installs a version of SQL ... Today the backups completely failed, could not even backup single file ...
    (microsoft.public.windows.server.sbs)
  • Re: Event 208 Error
    ... Below is what the maintenance plan ... [ODBC SQL Driver](SQL Server) cannot allow ... Perform a full backup, or differntial database, ...
    (microsoft.public.sqlserver.server)