How to configure the server notification in SQL 2005.

9 Dec 2005 9:17 PM

=== Steve L ===

I couldn't find anything in the book online or tutorial addressing
this question.
Does anyone know how and what version of Outlook should be used?

Thank you!

9 Dec 2005 9:27 PM

Aaron Bertrand [SQL Server MVP]

Why do you need Outlook? If you use the new Database Mail feature, all you
need is an SMTP server willing to relay...

Show quote

"=== Steve L ===" <steve.***@powells.com> wrote in message
news:1134163048.351008.299170@f14g2000cwb.googlegroups.com...
>
> I couldn't find anything in the book online or tutorial addressing
> this question.
> Does anyone know how and what version of Outlook should be used?
>
> Thank you!
>

9 Dec 2005 10:37 PM

=== Steve L ===

hey thanks. that's nice to know and it worked.
how about 'operators'? in sql 2000 EM you can test the operators under
the property page, but that option is no long available in sql 2005.
any idea?
thank you

9 Dec 2005 10:42 PM

Aaron Bertrand [SQL Server MVP]

> how about 'operators'? in sql 2000 EM you can test the operators under
> the property page, but that option is no long available in sql 2005.
> any idea?

Never used them, probably never will. What do you plan on using them for?

9 Dec 2005 11:00 PM

=== Steve L ===

depends on the type of the scheduled jobs, the notification can go to
different users or emailing groups, or a pager. it's nice to be able to
test the validity of the operators before they go into production.

9 Dec 2005 11:05 PM

Aaron Bertrand [SQL Server MVP]

> depends on the type of the scheduled jobs, the notification can go to
> different users or emailing groups, or a pager.

With database mail, you can go to an e-mail address, or a distribution list,
or the e-mail address of the pager. Still not sure why you need an
"operator"...

A

10 Dec 2005 12:31 AM

=== Steve L ===

I don't know how to explain it more clear than I alredy did. pls take a
look of
How to: Notify an Operator of Job Status for details in BOL. hope that
helps.
I do appreciate your response; however, I believe my question was about
how to 'test' a operator like in sql 2000 EM, not about why one should
use it, or what the 'operator' is for. If you've never used it and
never will (as you said), pls don't let my question burnden you for an
answer. Thank you.

10 Dec 2005 9:40 AM

Tibor Karaszi

How about having a test job which just sends an email that you run on demand?

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/

Show quote

"=== Steve L ===" <steve.***@powells.com> wrote in message
news:1134169235.025163.56700@o13g2000cwo.googlegroups.com...
> depends on the type of the scheduled jobs, the notification can go to
> different users or emailing groups, or a pager. it's nice to be able to
> test the validity of the operators before they go into production.
>