I have created a database stored procedure that uses a cursor to (amongst other things) update about a thousand rows in a 10,000 row table.<br><br>Performing EXEC {DbName}.{ProcedureName} within query analyzer completes the task in about 2 seconds.<br><br>However, scheduling the same task through SQLServerAgent takes in the region of 50 seconds to complete.<br><br>Am I correct in thinking that SQLServerAgent uses ODBC to communicate with the DB ?? If so, any ideas on a way around this - The job is to be scheduled to run once a minute to update time counters on certain records. 2 seconds is OK - 50 seconds leaves things a bit tight on a 1 minute schedule.<br><br>Cheers<br><br>Chris.