Forum Discussion
garnetblack
3 years agoFrequent Visitor
Scheduled Refresh Not Running
I have a dataset that has been refreshing every 30 min for over a year with no isues, as of Friday at 12:06 PM they just stopped running, No Failures, On Demand workes fine, All cloud based Azure SQL...
GilbertQ
3 years agoSuper User
dmitri_zaikine
2 years agoRegular Visitor
Good day, we have the same issue:
1) I create a scheduled refresh in the Report Server to run every 30 minutes, starting at 2am.
2) it runs only once a day : at 2 am
3) on the MSSSQL server side I can see the corresponding SQL Agent job, and the schedule is missing 30 mins interval .
4) Report Server side does not have job execution logs , but MSSQL server has them.
5) If I modify the SQL Agent job to run every 30 mins - it runs as expected ....
6) but I can not modify it vi Report Server , interval of 30 mins is not accepted.
Thank you for yout help.