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