Not sure about Azure and what is available or not - but lookup WAITFOR in BOL. That will allow your process to sleep for a time and start up again.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs