Jack Vamvas shows how you can check on the SQL Server Agent status using T-SQL:
I want to check if SQL Server Agent is running using t-sql. I know I can check through the services.msc or other methods such as Powershell scripts to report on the SQL Server Agent status , but the requirement is to extract this information via t-sql. Do you have a script using t-sql to get the SQL Server Agent Status?
There is a method and Jack shows us the way.