Here is the code that you need to put your process into sleep mode:
declare @wait_time nvarchar(255)
print 'start working on it.. => current ms: ' + cast(datepart(millisecond, getdate()) as nvarchar)
set @wait_time = '00:00:00.' + left(cast(cast(rand() * 1000 as int) as nvarchar), 3)
waitfor delay @wait_time
print 'im done and waited for ' + @wait_time
+ ' => current ms: '
+ cast(datepart(millisecond, getdate()) as nvarchar)
No comments:
Post a Comment