Data Alert - AlterIntervalMins

Question

Data Alert - AlterIntervalMins

Dom 976

We are setting up alerts from our SSRS portal (SQL Server 2016). [Note: these are NOT SharePoint alerts - just set up in SSRS.]

We have seen that the alert can check for a condition every five minutes based on the ExecutionIntervalSecs parameter. What does AlterIntervalMins do? And Use TransactionIDIterator?

User's image

Vahid Ghafarpour 23,605 Reputation points

2023-05-29T18:19:53.69+00:00

I think you have implemented a custom solution or used third-party tools to enable alerts in your SSRS environment, the parameters you mentioned may be specific to that particular solution or tool. To understand the functionality of AlterIntervalMins and UseTransactionIDIterator, I recommend consulting the documentation or resources provided by the solution or tool you are using for alerts in SSRS.
Dom 976 Reputation points

2023-05-29T18:53:34.1766667+00:00

Ahhh. If only there was any documentation or resources! Nope, I inherited this system and guess we are on our own. We will have to just experiment with the values and see what comes out. Thanks for the info, though.