You can use the sp_get_sqlagent_properties undocumented stored procedure to retrieve the SQL Agent properties of a SQL Instance. It is available in SQL Server MSDB database. This procedure only works if the SQL Agetn Service is started.
Script to get the SQL Agent Properties
Written by
in
Thanks for the comment, will get back to you soon… Jugal Shah