January 14, 2018 at 1:15 pm
Hi All,
Need power shell script to restart SSAS server form another SSIS - SQL Agent job step
We are restarting SSAS regularly, but my plan is to set up a job in SSIS, schedule the job after all our daily load job completes and make the SSAS restart remotely.
Both SSAS & SSIS are different servers.
Help on the script. with the examples. Thanks
January 14, 2018 at 7:55 pm
Oh, FFS, Got Google?
https://www.databasejournal.com/features/mssql/managing-sql-server-services-with-powershell.html
should give you a pretty good idea.
January 15, 2018 at 4:37 pm
yup thanks. i have tried this and created a job in ssis.
Through direct poweshell it works but i cant run though the sql agent job
I have created a sql agent job to execute powershell script.
this is to stop SSAS service in another server.
Script :
Get-service MSSQLServerOLAPService -ComputerName vmpid-g4uwbi02 | stop-service
Start-Sleep -s 60
Get-service MSSQLServerOLAPService -ComputerName vmpid-g4uwbi02 | start-service
Job completes with no action : result as :
The job script encountered the following errors. Theseerrors did not stop the script: A job step received an error at line 1 ina PowerShell script. The corresponding line is 'Get-service MSSQLServerOLAPService-ComputerName vmpid-g4uwbi02 | stop-service '. Correct the script andreschedule the job. The error information returned by PowerShell is: 'Cannotfind any service with service name 'MSSQLServerOLAPService'
Kindly help
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy