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.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Problem with SQLServerAgent Performance
- Thread starter clawton
- Start date
- Status
Similar threads
- Locked
- Question