Hi,

We are using SQL 2005. I'm trying to setup an operator who can have more
than 2 emails, is that possible?
Otherwise, is there any other way I can notify at least 2 DBAs when the job
failed.

Thanks a lot in advance,
Sarah

YEs. I believe that both semi-colon and comma separated work. I'm 100% that one of them work. Give
it a try and you will see...

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"sg" <sg@discussions.microsoft.com> wrote in message
news:5CBA1160-4545-4BD8-8DC5-5C0E414A453D@microsoft.com...
> Hi,
>
> We are using SQL 2005. I'm trying to setup an operator who can have more
> than 2 emails, is that possible?
> Otherwise, is there any other way I can notify at least 2 DBAs when the job
> failed.
>
> Thanks a lot in advance,
> Sarah

Hi Tibor,

This works great on production. However, I was doing a test on our test
server, it didn't work, I'm wondering if there is some configuration needed
to be turned on.

Thanks a lot,
Sarah

"Tibor Karaszi" wrote:

> YEs. I believe that both semi-colon and comma separated work. I'm 100% that one of them work. Give
> it a try and you will see...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
>
> "sg" <sg@discussions.microsoft.com> wrote in message
> news:5CBA1160-4545-4BD8-8DC5-5C0E414A453D@microsoft.com...
> > Hi,
> >
> > We are using SQL 2005. I'm trying to setup an operator who can have more
> > than 2 emails, is that possible?
> > Otherwise, is there any other way I can notify at least 2 DBAs when the job
> > failed.
> >
> > Thanks a lot in advance,
> > Sarah
>
>

What does "didn't work" mean? Do you get an error message? If so, what is
it? Have you tried just sending a basic e-mail from your own e-mail client,
through the same SMTP server, with two or more recipients?


On 9/8/08 1:44 PM, in article
3354555B-CEEA-4CC0-AAB6-411CCB0D2F1B@microsoft.com, "sg"
<sg@discussions.microsoft.com> wrote:

> Hi Tibor,
>
> This works great on production. However, I was doing a test on our test
> server, it didn't work, I'm wondering if there is some configuration needed
> to be turned on.
>
> Thanks a lot,
> Sarah
>
> "Tibor Karaszi" wrote:
>
>> YEs. I believe that both semi-colon and comma separated work. I'm 100% that
>> one of them work. Give
>> it a try and you will see...
>>
>> --
>> Tibor Karaszi, SQL Server MVP
>> http://www.karaszi.com/sqlserver/default.asp
>> http://sqlblog.com/blogs/tibor_karaszi
>>
>>
>> "sg" <sg@discussions.microsoft.com> wrote in message
>> news:5CBA1160-4545-4BD8-8DC5-5C0E414A453D@microsoft.com...
>>> Hi,
>>>
>>> We are using SQL 2005. I'm trying to setup an operator who can have more
>>> than 2 emails, is that possible?
>>> Otherwise, is there any other way I can notify at least 2 DBAs when the job
>>> failed.
>>>
>>> Thanks a lot in advance,
>>> Sarah
>>
>>

Hi Aaron,

Sorry, I didn't explain clearly.

I setup a test job on purpose on test server, It will fail. I setup when the
job fail, send an email to operator DBA (including 2 DBAs). However, after
running the job, the job failed, I didn't get email. I did same test on
production server, it works.

Hope this is clearly this time.
Sarah

"Aaron Bertrand [SQL Server MVP]" wrote:

> What does "didn't work" mean? Do you get an error message? If so, what is
> it? Have you tried just sending a basic e-mail from your own e-mail client,
> through the same SMTP server, with two or more recipients?
>
>
> On 9/8/08 1:44 PM, in article
> 3354555B-CEEA-4CC0-AAB6-411CCB0D2F1B@microsoft.com, "sg"
> <sg@discussions.microsoft.com> wrote:
>
> > Hi Tibor,
> >
> > This works great on production. However, I was doing a test on our test
> > server, it didn't work, I'm wondering if there is some configuration needed
> > to be turned on.
> >
> > Thanks a lot,
> > Sarah
> >
> > "Tibor Karaszi" wrote:
> >
> >> YEs. I believe that both semi-colon and comma separated work. I'm 100% that
> >> one of them work. Give
> >> it a try and you will see...
> >>
> >> --
> >> Tibor Karaszi, SQL Server MVP
> >> http://www.karaszi.com/sqlserver/default.asp
> >> http://sqlblog.com/blogs/tibor_karaszi
> >>
> >>
> >> "sg" <sg@discussions.microsoft.com> wrote in message
> >> news:5CBA1160-4545-4BD8-8DC5-5C0E414A453D@microsoft.com...
> >>> Hi,
> >>>
> >>> We are using SQL 2005. I'm trying to setup an operator who can have more
> >>> than 2 emails, is that possible?
> >>> Otherwise, is there any other way I can notify at least 2 DBAs when the job
> >>> failed.
> >>>
> >>> Thanks a lot in advance,
> >>> Sarah
> >>
> >>
>
>

Not really, as you haven't really explained everything you tried. Does the
notification work if the operator only has a single e-mail address? Have
you checked the logs of the SMTP server to see if the message was received,
or if it was not relayed, why?




On 9/8/08 3:17 PM, in article
F1F691B0-0A9C-40D9-A60C-A233E1671385@microsoft.com, "sg"
<sg@discussions.microsoft.com> wrote:

> Hi Aaron,
>
> Sorry, I didn't explain clearly.
>
> I setup a test job on purpose on test server, It will fail. I setup when the
> job fail, send an email to operator DBA (including 2 DBAs). However, after
> running the job, the job failed, I didn't get email. I did same test on
> production server, it works.
>
> Hope this is clearly this time.
> Sarah
>
> "Aaron Bertrand [SQL Server MVP]" wrote:
>
>> What does "didn't work" mean? Do you get an error message? If so, what is
>> it? Have you tried just sending a basic e-mail from your own e-mail client,
>> through the same SMTP server, with two or more recipients?
>>
>>
>> On 9/8/08 1:44 PM, in article
>> 3354555B-CEEA-4CC0-AAB6-411CCB0D2F1B@microsoft.com, "sg"
>> <sg@discussions.microsoft.com> wrote:
>>
>>> Hi Tibor,
>>>
>>> This works great on production. However, I was doing a test on our test
>>> server, it didn't work, I'm wondering if there is some configuration needed
>>> to be turned on.
>>>
>>> Thanks a lot,
>>> Sarah
>>>
>>> "Tibor Karaszi" wrote:
>>>
>>>> YEs. I believe that both semi-colon and comma separated work. I'm 100% that
>>>> one of them work. Give
>>>> it a try and you will see...
>>>>
>>>> --
>>>> Tibor Karaszi, SQL Server MVP
>>>> http://www.karaszi.com/sqlserver/default.asp
>>>> http://sqlblog.com/blogs/tibor_karaszi
>>>>
>>>>
>>>> "sg" <sg@discussions.microsoft.com> wrote in message
>>>> news:5CBA1160-4545-4BD8-8DC5-5C0E414A453D@microsoft.com...
>>>>> Hi,
>>>>>
>>>>> We are using SQL 2005. I'm trying to setup an operator who can have more
>>>>> than 2 emails, is that possible?
>>>>> Otherwise, is there any other way I can notify at least 2 DBAs when the
>>>>> job
>>>>> failed.
>>>>>
>>>>> Thanks a lot in advance,
>>>>> Sarah
>>>>
>>>>
>>
>>

.... also, one work and the other doesn't work. Do they both use the same mail subsystem (Db Mail or
SQL Mail). And did you try both , and ; as separators?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Aaron Bertrand [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
news:C4EAF584.11D1F%ten.xoc@dnartreb.noraa...
> Not really, as you haven't really explained everything you tried. Does the
> notification work if the operator only has a single e-mail address? Have
> you checked the logs of the SMTP server to see if the message was received,
> or if it was not relayed, why?
>
>
>
>
> On 9/8/08 3:17 PM, in article
> F1F691B0-0A9C-40D9-A60C-A233E1671385@microsoft.com, "sg"
> <sg@discussions.microsoft.com> wrote:
>
>> Hi Aaron,
>>
>> Sorry, I didn't explain clearly.
>>
>> I setup a test job on purpose on test server, It will fail. I setup when the
>> job fail, send an email to operator DBA (including 2 DBAs). However, after
>> running the job, the job failed, I didn't get email. I did same test on
>> production server, it works.
>>
>> Hope this is clearly this time.
>> Sarah
>>
>> "Aaron Bertrand [SQL Server MVP]" wrote:
>>
>>> What does "didn't work" mean? Do you get an error message? If so, what is
>>> it? Have you tried just sending a basic e-mail from your own e-mail client,
>>> through the same SMTP server, with two or more recipients?
>>>
>>>
>>> On 9/8/08 1:44 PM, in article
>>> 3354555B-CEEA-4CC0-AAB6-411CCB0D2F1B@microsoft.com, "sg"
>>> <sg@discussions.microsoft.com> wrote:
>>>
>>>> Hi Tibor,
>>>>
>>>> This works great on production. However, I was doing a test on our test
>>>> server, it didn't work, I'm wondering if there is some configuration needed
>>>> to be turned on.
>>>>
>>>> Thanks a lot,
>>>> Sarah
>>>>
>>>> "Tibor Karaszi" wrote:
>>>>
>>>>> YEs. I believe that both semi-colon and comma separated work. I'm 100% that
>>>>> one of them work. Give
>>>>> it a try and you will see...
>>>>>
>>>>> --
>>>>> Tibor Karaszi, SQL Server MVP
>>>>> http://www.karaszi.com/sqlserver/default.asp
>>>>> http://sqlblog.com/blogs/tibor_karaszi
>>>>>
>>>>>
>>>>> "sg" <sg@discussions.microsoft.com> wrote in message
>>>>> news:5CBA1160-4545-4BD8-8DC5-5C0E414A453D@microsoft.com...
>>>>>> Hi,
>>>>>>
>>>>>> We are using SQL 2005. I'm trying to setup an operator who can have more
>>>>>> than 2 emails, is that possible?
>>>>>> Otherwise, is there any other way I can notify at least 2 DBAs when the
>>>>>> job
>>>>>> failed.
>>>>>>
>>>>>> Thanks a lot in advance,
>>>>>> Sarah
>>>>>
>>>>>
>>>
>>>
>