SQL Server Agent

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  November 30, 2006 at 6:42 am

  #62387

  Is the SQL Server Agent Auto Start option stored in the registry or within the database?

  Any ideas.

  TIA

• SA-1

  SSCrazy Eights

  Points: 8113

  More actions

  November 30, 2006 at 7:59 am

  #674926

  I got this information in msdb..sp_set_sqlagent_properties

• Kory Becker

  Hall of Fame

  Points: 3585

  More actions

  November 30, 2006 at 8:06 am

  #674937

  Registry!

  EM uses xp_instance_regwrite and xp_instance_regread to get and modify these settings.

• Pankaj Khanna

  Say Hey Kid

  Points: 707

  More actions

  December 5, 2006 at 1:28 am

  #675742

  Its in registry. You can verify this information from regedit:

  HKEY_LOCAL_COMPUTER\software\Microsoft\Microsoft SQL Server\<your instance>

  Pankaj Khanna
  Database Administrator - SQL Server 2000

  Keep hope to keep you intact...