Short tip this time around. If you are running SQL Server on Linux and connect to it from a Windows system with Management Studio (SSMS), the SQL Agent will be off. If you right click the Agent in SSMS try to get the properties of it, you will receive a lengthy error with this included:
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.
All good and normal. So how do you turn SQL Agent on?
Open a query window and execute this script:
'show advanced options'
FInally, right click on SQL Agent in SSMS and choose Refresh from the menu. You should now be able to access it.
SQL Server is a product of Microsoft Corporation.