SQL Agent would not start in a cluster and SQLAgent.OUT said SQL Server Agent terminated (normally). Here is what the log showed and how I fixed it.
SQL SERVER – FIX – Agent XPs Component is Turned Off as Part of the Security Configuration for this Server
New Maintenance Plan Wizard fails with ‘Agent XPs component is turned off as part of the security configuration’? Here is how to turn Agent XPs back on.
A Performance Counter Baseline Saved to a Table Every 15 Minutes
Save a performance counter baseline every 15 minutes, calculate interval rates, detect resets, and compare a defined week with last month.
SQL Agent Alerts for Severity 17 to 25 and Errors 823, 824, 825
Configure Agent alerts for serious severities and errors 823, 824 and 825, connect an operator to Database Mail, and test response delays.
mssql-conf: Configuring SQL Server on Linux Without a GUI
Use mssql-conf for SQL Server on Linux memory, file defaults, Agent, ports, and trace flags, then verify effective settings after restart.
NT SERVICE Accounts in sysadmin: What They Are For
A security scan wants those service logins gone. Here is how to see what each one is for before you click Delete.
SQL SERVER – Fix – Agent Starting Error 15281 – SQL Server blocked access to procedure ‘dbo.sp_get_sqlagent_properties’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server
SQL Server Agent fails to start with Error 15281 because Agent XPs are turned off? Here is how to enable Agent XPs with sp_configure and start the agent.