Hey Zabbix Community,
Looking for help with this SQL Trigger. Currently it is functioning, though I would like it to only trigger if the job fails TWICE, as they all are set to rerun upon failure and eventually do the 2nd run.
TRIGGER CODE:
{Template Microsoft SQL Server SA Baseline:job.mssql.status[{#SQLINSTANCENAME},{#JOBNAME}].last(0,0)}<>1 and {Template Microsoft SQL Server SA Baseline:job.mssql.status[{#SQLINSTANCENAME},{#JOBNAME}].last(0,0)}<>4
Please let me know if any of you know how to tackle this, any help is appreciated..
Thanks
Looking for help with this SQL Trigger. Currently it is functioning, though I would like it to only trigger if the job fails TWICE, as they all are set to rerun upon failure and eventually do the 2nd run.
TRIGGER CODE:
{Template Microsoft SQL Server SA Baseline:job.mssql.status[{#SQLINSTANCENAME},{#JOBNAME}].last(0,0)}<>1 and {Template Microsoft SQL Server SA Baseline:job.mssql.status[{#SQLINSTANCENAME},{#JOBNAME}].last(0,0)}<>4
Please let me know if any of you know how to tackle this, any help is appreciated..
Thanks