Count down from 0 to 5 seconds and repeat
WaitFor should help you accomplish this.

In your case we can simply pass a DELAY time as below

WAITFOR DELAY '00:00:05';


This will simply wait for 5 seconds, then return to the caller.