Ashish SQL LIFE

Sunday, 30 December 2012

Stored procedure for retrieving SQL Agent properties


sp_get_sqlagent_properties is and undocumented stored procedure to retrive the SQL Agent properties of a particular server. This stored procedure can be found in msdb database.

Usage:
EXEC msdb..sp_get_sqlagent_properties
Posted by Ashish at 05:48
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

Blog Archive

  • ►  2015 (16)
    • ►  May (2)
    • ►  April (4)
    • ►  March (5)
    • ►  February (4)
    • ►  January (1)
  • ►  2014 (9)
    • ►  August (1)
    • ►  May (2)
    • ►  April (6)
  • ►  2013 (28)
    • ►  July (8)
    • ►  June (3)
    • ►  May (4)
    • ►  March (6)
    • ►  January (7)
  • ▼  2012 (10)
    • ▼  December (10)
      • MOVING DATABASES IN SQL SERVER 2005 and SQL SERVER...
      • Stored procedure for retrieving SQL Agent properties
      • MSSQL SERVER Code Names with SQL server releases ...
      • Stored Procedure to find Primary keys and foreign ...
      • Recovery model and status of all databases
      • SQL Server Migration Checklist
      • SQL SERVER – DISABLE and ENABLE user SA
      • How we can connect with sql server cmd mode :-
      • Backup Database to multiple locations simultaneous...
      • SQL SERVER – A Quick Script for Point in Time Reco...

About Me

Ashish
View my complete profile
Simple theme. Powered by Blogger.