mssql-server-linux-1 and SQL server Agent

[Maateuszz]

trafficstars

Hello, I am trying to enable SQL Server agent on linux container as it was disabled by default. I did run directly in MSSMS: --Run sp_configure to check 'Agent XPs' value: EXEC SP_CONFIGURE 'Agent XPs'

--Enable advanced option to see all of the advanced configuration values: EXEC SP_CONFIGURE 'show advanced options',1 GO RECONFIGURE GO EXEC SP_CONFIGURE 'show advanced options'

--Run sp_configure again to check the value for Agent XPs EXEC SP_CONFIGURE 'Agent XPs',1 GO RECONFIGURE

After it was enabled and I created my first job but I am getting an error when trying to run it: I can not start SQL Server agent (Start button is greyed out).

Can You please advise on this?

[Maateuszz]

I did run "sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true" over SHH and it is ok right now :) Thanks

[Ziomal004]

the above SSMS method failed for me as well. I also struggle while I am trying to run the command sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true

when I'm trying sudo - it says sudo is not installed. Without using sudo I am getting an error stating that user should be superuser or part of mssql group, while the user is mssql (wtf?)

I have my container deployed on QNAP NAS device and yes I also asked on qnap foum. Anyone could please support me here, as I'm really struggling to get this done right.

[m32]

the above SSMS method failed for me as well. I also struggle while I am trying to run the command sudo /opt/mssql/bin/mssql-conf set sqlagent.enabled true

when I'm trying sudo - it says sudo is not installed. Without using sudo I am getting an error stating that user should be superuser or part of mssql group, while the user is mssql (wtf?)

I have my container deployed on QNAP NAS device and yes I also asked on qnap foum. Anyone could please support me here, as I'm really struggling to get this done right.

run inside dockers bash: cat >/var/opt/mssql/mssql.conf <<-EOF [sqlagent] enabled = true errorlogfile = /var/opt/mssql/log/sqlagent.log errorlogginglevel = 4 startupwaitforalldb = 0 EOF