Oct 13, 2009
how to execute a SP or table query every 5secs + SQL SERVER
The below query would make a delay of 5secs in calling he SP.
While 1 = 1
EXEC dbo.UpdateCustomer // executes the SP named UpdateCustomer
waitfor delay '00:00:05'
Here the delay notification is in hrs:Mins:secs
Mukund The Lion
Tuesday, October 13, 2009
Post a Comment
Post Comments (Atom)