If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Expression to find latest record

Started by mgzryq, 27 Jan 2010 04:35:06 PM

Previous topic - Next topic

mgzryq

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?