alter procedure spServiceController @Server varchar(250), @Command varchar(250), @Service varchar(250)
as
SET NOCOUNT ON

CREATE table #result(data varchar(100))


-- MSSQLServerOLAPService
declare 
@SCCmd VARCHAR(1000) = ''' sc \\' + @Server + ' ' + @Command + ' ' + @Service + '''',
@State varchar(250) = CASE WHEN @Command = 'start' then 'RUNNING'
						   WHEN @Command = 'stop' then 'STOPPED'
					  END 

EXEC ('exec master..xp_cmdshell ' + @SCCmd + ', ''no_output''' )

--Get Service Status
DECLARE @STATUS VARCHAR(100) = 'OTHER'
DECLARE @TimeOutInit datetime = current_timestamp

SET @SCCmd = ''' sc \\' + @Server + ' query ' + @Service + ' |find "STATE"'''

WHILE @STATUS <> @State AND DATEDIFF(SECOND, @TimeOutInit, current_timestamp) <= 120
BEGIN
	
	EXEC ('INSERT INTO #result exec master..xp_cmdshell ' + @SCCmd)
	
	SELECT TOP 1 @STATUS = CASE WHEN data like '%'+ @State +'%' THEN @State
					       ELSE @STATUS
					       END
	FROM #result WHERE data IS NOT NULL AND data like '%'+ @State +'%'
				   
END

SELECT 'SERVICE: ' + @Service + ' ON SERVER: ' + @Server + ' IS ' + @STATUS