SQL 2000 Email issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Happy New Year to All

I have two SQL Servers running

1. SQL 2000 Developers Editon 8.00.2050 on my Windows XP Pro workstation
2. SQL 2000 Server Standard Edition 8.00.2050 on my
Windows 2003 R2 Standard DC server

I have Outlook 2002 SP3 Client installed on both computers.

I have a valid email profile on both.

The services for sql server and sql agent use the same logon account as to
the machine being logged onto. This is the same on both also.

The SQL server properties have the mail profile defined in both

The SQL Agent on both have been configured with the Mail profile.

The Support Services SQL Mail has been configured with a valid mail profile
on both.

Tested the Support Services SQL Mail configuration on both and they both are
successfull.

The TEST on the SQL Agent properties for SQL Mail profile works on both.

Created a operator on both but the same email address in both and tested
both and they both worked.

Now you ask what is my issue. Well it seems I have email working on both
server this is true.

On Server 1 My workstation I have maintainance plans setup and the jobs run
every day and after each run I get a email telling me the job was
successful. It will also send me a email if the job fails. I have setup the
alerts to do that.
So server 1 is working to my liking.

On Server 2 My Server I have maintainance plans also setup which created
jobs. The jobs are running successfully but I am not getting any emails that
the jobs completed successfully.

That is my problem, I have gone over the settings on both servers and I can
not see any thing that is missing.

The Alerts Only allow one type so I do not know how to use alerts in a
different way.

Does any one know what I am missing?

Any ideas or suggestions?

Thanks

Tom


.

Relevant Pages

  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)
  • RE: How do I get back to base SQL server on my SBS 2003 server?
    ... After you uninstall SQL 2005, the instance which you upgraded will not go ... Uninstall and then reinstall ISA server. ... Uninstall and then reinstall the Monitoring component. ... Tools to Maintenance, change Monitoring component to Install, and then ...
    (microsoft.public.windows.server.sbs)