Standard Edition of SQL Server supports notifying operators at the
completion of jobs. There should be plenty of support info on MSDN and
in the newsgroups on this.
SQL Server MVP
Get up to speed quickly with SQLNS
I support PASS, the Professional Association for SQL Server.
On Mon, 12 Dec 2005 09:06:03 +0200, "Sanjeev" <[email protected]>
>Thanks for the suggestion.
>I have tried this out but with no success either.
>I do not have Enterprise sku installed, instead I have Standard edition.
>In reporting services, Data driven subscriptions do not work with Standard
>Edition but it does with Enterprise.
>I'm beginning to wonder if the same applies for operators since they seem to
>work on the same mailing principle.
>"Joe Webb" <[email protected]> wrote in message
>> Although the term "notification services" sounds like the appropriate
>> newsgroup, you'll have more luck in the
>> microsoft.public.sqlserver.server newsgroup. This group is dedicated
>> to SQL Server Notification Services, an add-on to SQL Server 2000 and
>> an integrated part of SQL Server 2005.
>> I can tell you that in teaching the 2072 class (SQL Server 2000
>> Administration) I occassionally see issues with configuring operators
>> to receive alerts. Usually, reseting the SQL Server Agent and SQL
>> Server service to use the same, appropriately configured log on
>> creditials resolves the issue. I say resetting, but they are already
>> configured correctly, however it doesn't work. Setting them again,
>> seems to resolve it.
>> Joe Webb
>> SQL Server MVP
>> Get up to speed quickly with SQLNS
>> I support PASS, the Professional Association for SQL Server.
>> On Fri, 9 Dec 2005 15:21:09 +0200, "Sanjeev" <[email protected]>
>>>I am trying to set up an operator using SQL Server 2000 to send email
>>>when a certain job has failed.
>>>When i go to the properties of the operator and click the three dots next
>>>the email name I get the error message below
>>>"unable to logon to mail system. you should open a mail client(microsoft
>>>outlook or microsoft exchange client) to use this service"
>>>However, I have microsoft outlook installed which sends and receives mail
>>>without any problems.
>>>Plus I did set up a mail profile which I tested and it gave the following
>>>"Successfully started(and stopped) a mail session with this profile."
>>>Then I pressed the test button next to the three dots and it came up with
>>>this error message
>>>"Error 22022 :SQLServerAgent Error : The SQLServerAgent mail session is
>>>running;check the mail profile and/or the SQLServerAgent service startup
>>>account in the SQLServerAgent properties dialog"
>>>The error message in the SQL Server agent log reads
>>>" The mail system failed to initialize; check that a mail client been
>>>Any ideas how to sove this one?