Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-19 : 08:37:10
|
| alexia writes "I made a subscription in reporting services and schedule it to post a report via email.But the subscription is not working well....The jobs were created but I didn't get any notification email...The question is, what should I check / configure ? Is there any missing settings ? I'm using outlook express...(not Microsoft Outlook), is it problem ?" |
|
|
jhermiz
3564 Posts |
Posted - 2006-01-27 : 00:14:08
|
quote:
Originally posted by AskSQLTeam
alexia writes "I made a subscription in reporting services and schedule it to post a report via email.But the subscription is not working well....The jobs were created but I didn't get any notification email...The question is, what should I check / configure ? Is there any missing settings ? I'm using outlook express...(not Microsoft Outlook), is it problem ?"
Couple of things to check...First if you used a query or sproc to return the data make sure it runs correctly in Query Analyzer. Execute exec 'sprocname' (put the name of your sproc in sprocname) and make sure you get the correct results.Next if that works out fine, check the SMTP relay. The SMTP mail should be setup so that mail can be sent from that box.Third delete the job directly in the report manager and recreate it. Make certain that the job is then found in your "Jobs" section of SQL Server and that the SQL Server agent is running. Try to right click that job in sql server and click "Run" or "Start"...see if it sends you the report.Check security permissions for the account that sends the mail, and the security of the person to receive the mailThanks,Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
subscription reporting services 2005 problem