Getting SQLAgent to Respond Faster
-
Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/jbijnens/3177.asp
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
-
Warning!
I was searching on the sqlagent error messages and a link brought me to this entry.
While reviewing the entry I performed a regedit and discovered that the location in the registry of my sqlagent parameters does not match the post.
My system was created from an upgrade of a SQL Server 2000 Failover cluster and the parameters are found in the path of
hkey_local_machine/software/microsoft/microsoft sql server/
mssql.1/sqlagent/
So before running the code verify your agent parameter location in the registry since based on the history of your upgrade path the registry may need to be updated differently.
-- Mark D Powell --
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply