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