Forum Discussion

xantari's avatar
xantari
Icon for Helper II rankHelper II
8 years ago

Scheduled Refresh notifications (On-Premise)

We can not find a way to get Refresh Notification failure emails when a scheduled data refresh occurs on-premise.   Apparently this has existed for a long time on Power BI (because they have to dea...
Power BI Report Server
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I have just realised that there is a "magic number" in that SQL that makes it work.

 

INNER JOIN msdb.dbo.sysjobs sj
				ON rs.ScheduleID = CAST(sj.name AS UNIQUEIDENTIFIER)
				   AND 101 = sj.category_id

the 101 is the category_id of the Job Category called "Report Server"

 

you can find these using the following.

 

USE msdb
GO

SELECT * FROM dbo.syscategories

 

I think 101 is safe on most systems but it may well be different on your installation

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks much Anonymous, for the info. Much Appriciated.

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    I extended the query above slightly in the following post to show the errors that are recorded by the refresh process

     

    Data Refresh Fail