A long-time client from New Zealand asked if I had a T-SQL script to check SQL Server Job History. Here is the simple one I use for all enabled Agent jobs.
SQL SERVER – SQL Server Agent Missing in SQL Server Management Studio (SSMS)
A client could not see the SQL Server Agent node, it was missing in SQL Server Management Studio. Here are the possible causes, starting with sysadmin rights.
SQL SERVER – Unable to Start Service SQLSERVERAGENT on Server (mscorlib)
After moving the SQLAgent.OUT path, a client saw: Unable to start service SQLSERVERAGENT on server (mscorlib). Here is one cause of this error and the fix.
SQL SERVER – SQL Server Agent Not Starting – Failed to Initialize SQL Agent Log (Reason: Access is Denied).
SQL Server Agent would not start in my lab: Failed to initialize SQL Agent log (reason: Access is denied). Here is what I found in the log folder and the fix.
SQL SERVER – FIX: Msg 22004 – The Log File is Not Using Unicode Format
The SQL Server Agent log would not open in SSMS and showed Msg 22004, the log file is not using Unicode format. Here is the setting that fixed it.
SQL SERVER – How to Get SQL Server Agent Properties?
During a health check someone asked if SQL Server Agent has settings to tune. It does. Here is how to get SQL Server Agent properties with a simple script.
How to List All the SQL Server Jobs When Agent is Disabled? – Interview Question of the Week #171
When SQL Server Agent is disabled, you cannot expand it in SSMS to see its jobs. Here is how to list all the SQL Server Jobs with a simple query instead.