Is there a way for me to programmatically (some configuration setting in a table / registry entry etc, I'm hoping) change the default value in the Auto Refresh setting to 5 seconds instead of 60, and to set the Auto Refresh to ON?

I need a way to make this a permanent setting - hopefully so that it applies to all users of the server.

Here I fixed your screen shot

  • Try looking at below settings and play on stage: Jan 21, 2016 at 17:28
  • Go to registry on your SQL Server machine and go to following. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\ MSSQL11.YOUR_INSTANCE_NAME\SQLServerAgent Jan 21, 2016 at 17:28
  • If I am managing a server with that many jobs I would not be using Job Activity Monitor...I like to use Idera's Job Manager (free by the way), much more efficient and believe you can set the auto refresh: idera.com/productssolutions/freetools/sqljobmanager
    – user507
    Jan 21, 2016 at 17:31
  • @TheGameiswar anything under that registry for SQLServerAgent is dealing with the SQL Server service on the server itself, it has nothing to do with an installation of SSMS on a desktop.
    – user507
    Jan 21, 2016 at 17:34


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.