Forum Discussion
SQL Server Agent enabled but not able to start/stop it to run DB jobs
we installed MS Sql Server 2022 standard edition DB at on-prem K8S cluster using helm chart (taken from: https://artifacthub.io/packages/helm/mssql/mssql/1.1.2 )
and added following configuration to helm chart(templates/primary/statefulset.yaml) to enable SQL Server agent
name: MSSQL_AGENT_ENABLED
value: "true"
and was trying also to trigger from sa user:
EXEC sp_configure 'show advanced options', 1;
RECONFIGURE;
EXEC sp_configure 'Agent XPs', 1;
RECONFIGURE;
however, although SQL server agent is enabled, i'm still not able to start or stop it when login as sa user, what helm chart configuration or sql statement i can execute to start it?
for example:
3 Replies
can you start via des SQL Configuration Manager (not SSMS)?
Why on earth do you want to manage a Windows service by SSMS?
Logon to the server with RDP and use the normal Windows tools, here Service Manager.
Anyway, you have to setup WMI the rigth way do manage services via SSMS, see
That little green "play" symbol on the SQL Server Agent icon and the fact that you can expand the SQL Server Agent section would indicate that the Agent is already started and you can go ahead and create/run jobs.
