I have a stored procedure that I also execute via scheduled job. When I execute the stored procedure, all the records update and I get the correct result.
When I schedule this same stored procedure to run via a scheduled job, every 30 minutes, all the records do not update as they do when I just execute the stored procedure in a query analyser window. Two or thre records at a time will update.
We are usng SQL 2008. Has anyone else seen this behavior?