December 22, 2005 at 2:03 pm
Does anyone know of a way to email the error that Report Manager produces when an end user gets that error when they try to acces a report
December 23, 2005 at 1:51 pm
You problaby could create a report based on a query on the executionlog table from the reportserver database. Combined with a data-driven subscription wich fires only when the ciriteria in the query on the status field is met and a frequent schedule, like every half hour you should be informed in time.
for example:
report based on query:
select name,timestart,username,status
from reportserver.dbo.ExecutionLog E
join reportserver.dbo.catalog C on c.itemID =E.reportID
where status <> 'rsSuccess' and convert(int,timestart)= convert(int,getdate())
and
datadriven subscription based on query
select distinct 'youremailadres@domain.com' as email
from reportserver.dbo.ExecutionLog E
join reportserver.dbo.catalog C on c.itemID =E.reportID
where status <> 'rsSuccess' and convert(int,timestart)= convert(int,getdate())
Ruud
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply