http://sqlblog.com/blogs/linchi_shea/archive/tags/SQL+puzzle/default.aspxTags: SQL puzzleenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/linchi_shea/archive/2010/08/25/sql-server-puzzle-why-are-the-sql-agent-jobs-executing-twice.aspxWed, 25 Aug 2010 21:13:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28277Linchi Shea5http://sqlblog.com/blogs/linchi_shea/comments/28277.aspxhttp://sqlblog.com/blogs/linchi_shea/commentrss.aspx?PostID=28277I recently ran into a rather freakish case in which many SQL Agent jobs on a SQL Server 2005 instance were reported to run twice at their scheduled times. And the 2 nd run took place either at almost exactly the same time or only a second or two later....(<a href="http://sqlblog.com/blogs/linchi_shea/archive/2010/08/25/sql-server-puzzle-why-are-the-sql-agent-jobs-executing-twice.aspx">read more</a>)<img src="http://sqlblog.com/aggbug.aspx?PostID=28277" width="1" height="1">ClusterSQL puzzleSQL Agent