Forum Discussion
Error while scheduled refresh
How many scheduled refreshes are implemented? You can also check this at sql server agent and take a look to the jobs are named with uniqueidentifiers.
- Anonymous7 years agoNot applicable
AnonymousThis sounds interesting. How can I access the sql server agent to view the scheduled refreshes?
- Anonymous7 years agoNot applicable
Hi Anonymous
Go to the Management Studio from the sQL Server.
As a system admin you can view the SQL Server Agent Jobs
https://docs.microsoft.com/en-us/sql/ssms/agent/sql-server-agent?view=sql-server-2017
Best Regrads,
Philipp
- Anonymous7 years agoNot applicable
AnonymousI can imagine that data sets scheduled in the Power BI service use SQL Server agent jobs in the background to refresh the datasets. If you can get access to that agent (e.g. using XMLA) , then you can see which refreshes are scheduled at what time. If this is true and somebody knows how to get (viewing) access to that agent please let me (and the rest of the community) know.