cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Omega
Impactful Individual
Impactful Individual

Notification email in case of subscription failure

Hi, 

 

We have SSRS reports that are scheduled to us on daily basis. We noticed that from time to time, the subscriptions fail to run and we have to re-run the subscriptions manually.

 

Is there a way to get a notification email such that when a subscription fails to run, users will receive an email on the same? I only want email for the failed subscriptions and not the full log. 

 

Please help. 

 

Thanks!

1 ACCEPTED SOLUTION
saglamtimur
Resolver II
Resolver II

Scheduled subscriptions are stored under SQL Server Agent Jobs, Using a GUID as name.

Under job Properties->Notifications ther is an option to send email when the job fails. This may help you.

You have to configure SQL server to send email before using this option.

jobs.PNG

View solution in original post

1 REPLY 1
saglamtimur
Resolver II
Resolver II

Scheduled subscriptions are stored under SQL Server Agent Jobs, Using a GUID as name.

Under job Properties->Notifications ther is an option to send email when the job fails. This may help you.

You have to configure SQL server to send email before using this option.

jobs.PNG

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps