How to stop/start SQL Server Analysis Services using SQL Server Agent job

Mar 20 Reputation points
2023-01-30T12:25:34.1166667+00:00

Hi, I need to restart my SQL Server Analysis Services instance (basically start and stop the instance) before processing the tabular model that is created on that instance. Data processing is managed by the step in the agent job, so the restart should be scheduled as a new step in that agent job. I googled the issue and found that I can actually use a powershell script that I can start from the agent job. The problem is that I'm not familiar with powershell and I'm not sure, if I'm doing the right thing as it doesn't work. Any advice would be appreciated!

Thank you in advance

Mar

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,237 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,231 questions
0 comments No comments
{count} votes

Accepted answer
  1. Olaf Helper 38,786 Reputation points
    2023-01-30T12:32:08.24+00:00

0 additional answers

Sort by: Most helpful