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

Email from Report Viewer?

Hello all,
This is a really dumb question and I am sure that the answer is No, but I
have to ask it to see what other options/solutions might be available to me.
A client currently uses a Crystal Report Viewer control that allows users to
email an exported report from a desktop application. They want to move to
SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
Viewer control that comes with ASP.NET 2.0.
Is there any way to get a report, which is created dynamically (the rdl is
created dynamically based on user preferences and doesn't "live" on the
reporting services server) emailed to a list of email addresses?
Since the report is created dynamically and doesn't live on the Reporting
Services Server, it doesn't look like scheduling is an option...
Thanks!
-BrianThis is not directly supported, but you could support it in some fashion in
your app. Just place a button in you app to email the report. Then call
RenderReport on the viewer object and render to the desired format (not html
since there is no server for the images, but pdf or excell will work). Your
app can then just email the report. Of course your app needs to handle
setting up the connection to the smtp server to send the email, but you
could probably hook into outlook if you really needed to.
I hope that help.s
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:3B131BB4-2517-42E0-A47E-CD59003ABC0C@.microsoft.com...
> Hello all,
> This is a really dumb question and I am sure that the answer is No, but I
> have to ask it to see what other options/solutions might be available to
> me.
> A client currently uses a Crystal Report Viewer control that allows users
> to
> email an exported report from a desktop application. They want to move to
> SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
> Viewer control that comes with ASP.NET 2.0.
> Is there any way to get a report, which is created dynamically (the rdl is
> created dynamically based on user preferences and doesn't "live" on the
> reporting services server) emailed to a list of email addresses?
> Since the report is created dynamically and doesn't live on the Reporting
> Services Server, it doesn't look like scheduling is an option...
> Thanks!
> -Brian|||Hi,
Also have a look at creating your own export extensions. It may initially be
long-winded but you could get it to do exactly what you want it to.
Regards
John.
"brianpmccullough" <bmccullough11@.comcast.net> wrote in message
news:3B131BB4-2517-42E0-A47E-CD59003ABC0C@.microsoft.com...
> Hello all,
> This is a really dumb question and I am sure that the answer is No, but I
> have to ask it to see what other options/solutions might be available to
> me.
> A client currently uses a Crystal Report Viewer control that allows users
> to
> email an exported report from a desktop application. They want to move to
> SSRS 2005, with a ASP.NET 2.0 front end. I would like to use the Report
> Viewer control that comes with ASP.NET 2.0.
> Is there any way to get a report, which is created dynamically (the rdl is
> created dynamically based on user preferences and doesn't "live" on the
> reporting services server) emailed to a list of email addresses?
> Since the report is created dynamically and doesn't live on the Reporting
> Services Server, it doesn't look like scheduling is an option...
> Thanks!
> -Brian