SSRS schedule failure intimation

Question

I am scheduling a report using SQL Server Reporting Services Subscription option. Suppose my rdl file is corrupted or my stored procedure has got some problem. Then the report won’t generate in its next turn. What can I have to get the intimation that the report does not generated properly?

Can I configure to get a mail on report generation failure

score 2 · Answer 1 · answered Feb 01 '12 at 17:03

2

SSRS report subscriptions generate job entries in SQL Agent. Find the corresponding agent job and set email alerts through it's properties for failure.

answered Feb 01 '12 at 17:03

hqrsie

421
3
4

score 0 · Answer 2 · edited Apr 13 '17 at 12:42

0

For what it's worth - while exploring my own similar question alert when any job in a job category fails, I uncovered that while it is true that SSRS report subscriptions generate job entries in SQL Agent, the failure of an SSRS report subscription does not fail the SQL job.

You can find the failure in ExecutionLogStorage.Status in theReportServer database.

edited Apr 13 '17 at 12:42

Community

1

answered May 22 '12 at 18:41

JHFB

2,874
6
39
64

SSRS schedule failure intimation

2 Answers2