I have a t-SQL stored proc, all it does is time stamp a row then WaitFor Delay '00:05:00' and then time stamps next row in a table. I scheduled this proc as sql agent job, it works fine. At our work place we use ASG Zeke scheduling tool to
schedule all our jobs. when scheduled as job on this tool for some reason the waitfor delay doesn't work, the time stamps happen immediately with out the 5 min delay. Any idea why this is happening...?
View Complete Post