Data-driven Subscription e-mail problem

Trying to test a data-driving subscription for 5 records for a specific
report. Run report interactively successfully in report services. Can't
figure out why e-mail is not being sent (set my e-mail address for all 5).
Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info
set correctly in rsReportServer Config file. Viewed the
ReportServer(date).log file and no information listed, checked windows
application log and report server is being activated successfully. Any
suggestions' Thanks. JanineAre you running RS on a Windows Server 2003? If so, I think that there is a
known issue that can be solved with a hotfix. We had a similar problem and it
wasn't the RS configuration that was causing the problem rather it was an
issue with Windows Server 2003. Sorry that I do not have any additional info.
"JanineB1129" wrote:
> Trying to test a data-driving subscription for 5 records for a specific
> report. Run report interactively successfully in report services. Can't
> figure out why e-mail is not being sent (set my e-mail address for all 5).
> Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer info
> set correctly in rsReportServer Config file. Viewed the
> ReportServer(date).log file and no information listed, checked windows
> application log and report server is being activated successfully. Any
> suggestions' Thanks. Janine|||Do regular subscriptions work?
You need to look in the reportserverservice<date>.log file for the errors.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"B. Mark McKinney" <BMarkMcKinney@.discussions.microsoft.com> wrote in
message news:02470CE4-B6B0-48E5-B387-BF0691124515@.microsoft.com...
> Are you running RS on a Windows Server 2003? If so, I think that there is
a
> known issue that can be solved with a hotfix. We had a similar problem and
it
> wasn't the RS configuration that was causing the problem rather it was an
> issue with Windows Server 2003. Sorry that I do not have any additional
info.
> "JanineB1129" wrote:
> > Trying to test a data-driving subscription for 5 records for a specific
> > report. Run report interactively successfully in report services. Can't
> > figure out why e-mail is not being sent (set my e-mail address for all
5).
> > Status showing "Done: 5 processed of 5; 5 errors". Verified SMTPServer
info
> > set correctly in rsReportServer Config file. Viewed the
> > ReportServer(date).log file and no information listed, checked windows
> > application log and report server is being activated successfully. Any
> > suggestions' Thanks. Janine

Databasemail

Hi,

i have set up databasemail to send me e-mail after my sql backup has finished.

Profile and account has bin configured,and test mail ha been sent. Works just fine.

But when my backup has finished, no e-mail is being sent.

Get this error message in error logs: [264] An attemtemt was made to send an e-mail when no email session was established.

My system is

Microsoft Windows Server 2003 R2. SP2. Standard Edition.

SQL sever 2005, sp2

Microsoft SQL Server Management Studio 9.00.3042.00
Microsoft Analysis Services Client Tools 2005.090.3042.00
Microsoft Data Access Components (MDAC) 2000.086.3959.00 (srv03_sp2_rtm.070216-1710)
Microsoft MSXML 2.6 3.0 6.0
Microsoft Internet Explorer 6.0.3790.3959
Microsoft .NET Framework 2.0.50727.832
Operating System 5.2.3790

DId you have a look on:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=354995&SiteID=1

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||You can use the below code as step two in your backup job to invoke mail alert.
Dont forget to change profilename,recipients, subject & body in the below code before inserting into job

Code Snippet

Exec msdb..sp_send_dbmail @.profile_name='<profilename>',
@.recipients='Your Email Address',
@.subject='Your Subject here',
@.body='Your Body Message',
@.query='SET NOCOUNT ON
select ''SERVER NAME : '' + @.@.servername
select SUBSTRING(s.name,1,40) AS ''Database Name'',
CAST(b.backup_start_date AS char(25)) AS ''Last Backup Date'',
CASE WHEN b.backup_start_date > DATEADD(dd,-1,getdate())
THEN ''Backup Completed ''
WHEN b.backup_start_date > DATEADD(dd,-7,getdate())
THEN ''Backup Older than One day ''
ELSE ''Backup Older than One Week ''
END
AS ''Status'',
substring(m.physical_device_name ,1,100) AS ''Backup File Name''

from master..sysdatabases s
LEFT OUTER JOIN msdb..backupset b
ON s.name = b.database_name
AND b.backup_start_date = (SELECT MAX(backup_start_date)
FROM msdb..backupset
WHERE database_name = b.database_name
AND type = ''D'' ) -- full database backups only, not log backups
left outer join msdb..backupmediafamily m
on m.media_set_id=b.media_set_id
and m.physical_device_name=(select max(physical_device_name) from msdb..backupmediafamily
where media_set_id=b.media_set_id)
WHERE s.name <> ''tempdb''
ORDER BY s.name'