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

BEGIN

EXEC dbo.UpdateCustomer // executes the SP named UpdateCustomer

waitfor delay '00:00:05'

END
 
Here the delay notification is in hrs:Mins:secs