Anyone know how I can create this as an alert and an application monitor?
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
select count(InvoicePDFLogID)
from invoicepdflog with (nolock)
where invoicecreateddate is null and created >= dateadd(day,-7,getdate())
Typically the alert files based on a value returned or the number of records returned.
The above alert runs against: vsnamsprod01.vit_ams
I have attached a screenshot of how this is currently setup in another monitoring tool we are trying to move away from.
