Email notifications setup

Hi
Sorry if this seems dumb, i have upgraded to sql 2000 and
am having a great time so far, but I have a little problem.
In my office only 5 people have email so we are using a
simple email server (workgroupmail) is support imap,pop
and all the other usuals.
my question is how do I set up sql server to allow me to
send emails when scheduled tasks run or dont run.
CheersIf you don't want to bother setting up exchange/mapi/outlook/sql mail, see
http://www.aspfaq.com/2403 for some other alternatives.
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"merlin" <anonymous@.discussions.microsoft.com> wrote in message
news:07ba01c3b685$e3c7bed0$a301280a@.phx.gbl...
> Hi
> Sorry if this seems dumb, i have upgraded to sql 2000 and
> am having a great time so far, but I have a little problem.
> In my office only 5 people have email so we are using a
> simple email server (workgroupmail) is support imap,pop
> and all the other usuals.
> my question is how do I set up sql server to allow me to
> send emails when scheduled tasks run or dont run.
> Cheers|||Hi
The following show how to set up mail on sqlserver:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnovba01/html/SQLServerE-mail.asp
and a whole lot more:
http://www.aspfaq.com/show.asp?id=2403
Without a exchange you may have to have a user logged into the server with
outlook open see (I am not sure if this has changed recently!!) :
http://tinyurl.com/wzx5
An alternative if you have SMTP is XPSMTP
http://www.sqldev.net/xp/xpsmtp.htm
You will have to write your own notification calls.
John
"merlin" <anonymous@.discussions.microsoft.com> wrote in message
news:07ba01c3b685$e3c7bed0$a301280a@.phx.gbl...
> Hi
> Sorry if this seems dumb, i have upgraded to sql 2000 and
> am having a great time so far, but I have a little problem.
> In my office only 5 people have email so we are using a
> simple email server (workgroupmail) is support imap,pop
> and all the other usuals.
> my question is how do I set up sql server to allow me to
> send emails when scheduled tasks run or dont run.
> Cheers