Wait until Success status in workflow

i want to built workflow with wait condition till SMo which is using store procedure return status as Success.

if return status is fail workflow will wait for 1hr and again try to execute same smo and check status, if status is success go to next activity or again wait for 1hr to execute.

can any one help to implement this logic