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!Why do you need Outlook? If you use the new Database Mail feature, all you
need is an SMTP server willing to relay...
"=== Steve L ===" <steve.lin@.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!
>|||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|||> 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?|||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.|||> 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|||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.|||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/
"=== Steve L ===" <steve.lin@.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.
>
Showing posts with label outlook. Show all posts
Showing posts with label outlook. Show all posts
Wednesday, March 21, 2012
Monday, March 19, 2012
how to configure SQL server 2000 Agent Mail to use outlook express
Hi,
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
BingOutlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing|||Thanks much for the response. I haven't done any stored procedure scripting
in SQL server 2000 environment. I'll check how the scripts you mentioned
work. On this SQL 2000 server, outlook is not installed.
Bing
"Geoff N. Hiten" wrote:
> Outlook Express does not provide the MAPI interface necessary for SQL Mail
> and SQL Agent Mail. Only Outlook provides that functionality.
> Personally, I do not use the built-in mail components. I use
> xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
> for SQL. It is not a drop-in replacement, but with a little scripting, you
> an duplicate the functionality without the instability and headaches of the
> MAPI-based built-in components.
> Note that SQL 2005 uses its own SMTP connector called Database Mail.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> > Hi,
> >
> > I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> > send out job notifications. On our SQL server 2000, I logged on as the
> > service account which runs both SQL server and SQL server agent. I was
> > able
> > to send mail manually from outlook express. But how should I make SQL
> > Agent
> > use outlook express? I've searched google but was not able to find any
> > step
> > by step instruction on that. I checked the properties of SQL Server
> > Agent.
> > Under the General tab, the Mail session is grayed out. I think that's
> > correct because outlook express doesn't have a profile. No other mail
> > configurations are available.
> >
> > I'd appreciate if anybody can shed some light or provide some pointers.
> >
> > Thanks,
> >
> > Bing
>
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
BingOutlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing|||Thanks much for the response. I haven't done any stored procedure scripting
in SQL server 2000 environment. I'll check how the scripts you mentioned
work. On this SQL 2000 server, outlook is not installed.
Bing
"Geoff N. Hiten" wrote:
> Outlook Express does not provide the MAPI interface necessary for SQL Mail
> and SQL Agent Mail. Only Outlook provides that functionality.
> Personally, I do not use the built-in mail components. I use
> xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
> for SQL. It is not a drop-in replacement, but with a little scripting, you
> an duplicate the functionality without the instability and headaches of the
> MAPI-based built-in components.
> Note that SQL 2005 uses its own SMTP connector called Database Mail.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> > Hi,
> >
> > I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> > send out job notifications. On our SQL server 2000, I logged on as the
> > service account which runs both SQL server and SQL server agent. I was
> > able
> > to send mail manually from outlook express. But how should I make SQL
> > Agent
> > use outlook express? I've searched google but was not able to find any
> > step
> > by step instruction on that. I checked the properties of SQL Server
> > Agent.
> > Under the General tab, the Mail session is grayed out. I think that's
> > correct because outlook express doesn't have a profile. No other mail
> > configurations are available.
> >
> > I'd appreciate if anybody can shed some light or provide some pointers.
> >
> > Thanks,
> >
> > Bing
>
how to configure SQL server 2000 Agent Mail to use outlook express
Hi,
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
Bing
Outlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing
|||Thanks much for the response. I haven't done any stored procedure scripting
in SQL server 2000 environment. I'll check how the scripts you mentioned
work. On this SQL 2000 server, outlook is not installed.
Bing
"Geoff N. Hiten" wrote:
> Outlook Express does not provide the MAPI interface necessary for SQL Mail
> and SQL Agent Mail. Only Outlook provides that functionality.
> Personally, I do not use the built-in mail components. I use
> xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
> for SQL. It is not a drop-in replacement, but with a little scripting, you
> an duplicate the functionality without the instability and headaches of the
> MAPI-based built-in components.
> Note that SQL 2005 uses its own SMTP connector called Database Mail.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
>
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
Bing
Outlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing
|||Thanks much for the response. I haven't done any stored procedure scripting
in SQL server 2000 environment. I'll check how the scripts you mentioned
work. On this SQL 2000 server, outlook is not installed.
Bing
"Geoff N. Hiten" wrote:
> Outlook Express does not provide the MAPI interface necessary for SQL Mail
> and SQL Agent Mail. Only Outlook provides that functionality.
> Personally, I do not use the built-in mail components. I use
> xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
> for SQL. It is not a drop-in replacement, but with a little scripting, you
> an duplicate the functionality without the instability and headaches of the
> MAPI-based built-in components.
> Note that SQL 2005 uses its own SMTP connector called Database Mail.
> --
> Geoff N. Hiten
> Senior Database Administrator
> Microsoft SQL Server MVP
>
>
> "bing" <bing@.discussions.microsoft.com> wrote in message
> news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
>
how to configure SQL server 2000 Agent Mail to use outlook express
Hi,
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
BingOutlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing
I've read with SP3, SQL Agent Mail can be set up to use outlook express to
send out job notifications. On our SQL server 2000, I logged on as the
service account which runs both SQL server and SQL server agent. I was able
to send mail manually from outlook express. But how should I make SQL Agent
use outlook express? I've searched google but was not able to find any step
by step instruction on that. I checked the properties of SQL Server Agent.
Under the General tab, the Mail session is grayed out. I think that's
correct because outlook express doesn't have a profile. No other mail
configurations are available.
I'd appreciate if anybody can shed some light or provide some pointers.
Thanks,
BingOutlook Express does not provide the MAPI interface necessary for SQL Mail
and SQL Agent Mail. Only Outlook provides that functionality.
Personally, I do not use the built-in mail components. I use
xp_smtp_endmail from www.sqldev.net. XP_smtp_sendmail is a smtp connector
for SQL. It is not a drop-in replacement, but with a little scripting, you
an duplicate the functionality without the instability and headaches of the
MAPI-based built-in components.
Note that SQL 2005 uses its own SMTP connector called Database Mail.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"bing" <bing@.discussions.microsoft.com> wrote in message
news:875C2067-DAF3-47B0-9A0A-C0DDA5636D4B@.microsoft.com...
> Hi,
> I've read with SP3, SQL Agent Mail can be set up to use outlook express to
> send out job notifications. On our SQL server 2000, I logged on as the
> service account which runs both SQL server and SQL server agent. I was
> able
> to send mail manually from outlook express. But how should I make SQL
> Agent
> use outlook express? I've searched google but was not able to find any
> step
> by step instruction on that. I checked the properties of SQL Server
> Agent.
> Under the General tab, the Mail session is grayed out. I think that's
> correct because outlook express doesn't have a profile. No other mail
> configurations are available.
> I'd appreciate if anybody can shed some light or provide some pointers.
> Thanks,
> Bing
Subscribe to:
Posts (Atom)