microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Operator, dial 911 please

Subject: Re: Operator, dial 911 please
From: Joe Webb
Date: Mon, 12 Dec 2005 21:03:50 -0600
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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.



-- 
Joe Webb
SQL Server MVP
http://www.sqlns.com


~~~
Get up to speed quickly with SQLNS
http://www.amazon.com/exec/obidos/tg/detail/-/0972688811 

I support PASS, the Professional Association for SQL Server.
(www.sqlpass.org)

On Mon, 12 Dec 2005 09:06:03 +0200, "Sanjeev" <[email protected]>
wrote:

>Hi Joe,
>
>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.
>
>Cheers
>Sanjeev
>
>"Joe Webb" <[email protected]> wrote in message 
>news:[email protected]
>>
>> 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.
>>
>> HTH...
>>
>> -- 
>> Joe Webb
>> SQL Server MVP
>> http://www.sqlns.com
>>
>>
>> ~~~
>> Get up to speed quickly with SQLNS
>> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>>
>> I support PASS, the Professional Association for SQL Server.
>> (www.sqlpass.org)
>>
>>
>> On Fri, 9 Dec 2005 15:21:09 +0200, "Sanjeev" <[email protected]>
>> wrote:
>>
>>>Hi,
>>>
>>>I am trying to set up an operator using SQL Server 2000 to send email 
>>>alerts
>>>when a certain job has failed.
>>>
>>>When i go to the properties of the operator and click the three dots next 
>>>to
>>>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
>>>message
>>>"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 
>>>not
>>>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
>>>"[355] The mail system failed to initialize; check that a mail client been
>>>installed"
>>>
>>>Any ideas how to sove this one?
>>>
>>>Thanks
>>>Sanjeev
>>> 
>

<Prev in Thread] Current Thread [Next in Thread>