Thursday, September 22, 2011

How to stop and start RS server

Step 1:

DECLARE @Time VARCHAR(20), @cmdline VARCHAR(200)

SET @Time  = CONVERT(VARCHAR(2),DATEPART(Hour, DATEADD(Mi, 1,GETDATE())))  +':' + CONVERT(VARCHAR(2), DATEPART(Mi, DATEADD(Mi, 1,GETDATE())))
SET @cmdline = 'AT \\svanwarsql02 '+@Time+' NET STOP ReportServer'
EXEC master..xp_cmdshell @cmdline

SET @Time  = CONVERT(VARCHAR(2),DATEPART(Hour, DATEADD(Mi, 1,GETDATE())))  +':' + CONVERT(VARCHAR(2), DATEPART(Mi, DATEADD(Mi, 2,GETDATE())))
SET @cmdline = 'AT \\svanwarsql02 '+@Time+' NET START ReportServer'
EXEC master..xp_cmdshell @cmdline

Step 2:

Wait for 5 mins to allow step 1 to finish

WAITFOR delay '00:05:00'

No comments:

Post a Comment