I have setup an audit database which, among other things, logs the status of all the scheduled JOBS run from CONNECTION. We have a series of nightly scheduled JOBS that run and the audit database has a record for each run and its status (success/failure). What I am now trying to do is write an event condition expression that test the status for the latest record (ie what is the status of the last run of a particular JOB) of a particular JOB, however, I'm not having much luck. Initially the expression would return the status of all records for that particular JOB. I have tried to use MAXIMUM to isolate the latest record but I keep getting syntax errors.
Any suggestions?