Steps to reproduce:

1. Install and configure as usual agent2+MSSQL plugin
2. Create host and apply template "MSSQL by Zabbix agent 2"
3. Prepare some DB jobs, disabled and enabled
4. Check output of item "MSSQL: Get job status" (mssql.job.status.get)

Result:
Enabled jobs reports fine, but any disabled job doesn't get reported. This makes that if a job is enabled, detected, and then disabled, the items are marked for removal.
This doesn't seems to be right because there is an item prototype for job status:
MSSQL Job '{#JOBNAME}': Enabled with key mssql.job.enabled"{#JOBNAME}"
But with the current behaviour this item will always return 1

I think the problem might be in the query job.status.get.sql, line 29:

WHERE enabled = 1

Expected:
Both enabled and disabled jobs should be monitored. If the actual behaviour is right, then remove item prototype mssql.job.enabled or clarify its utility