Forum Discussion

bsveritas's avatar
bsveritas
Level 1
8 years ago

OpsCenter SQL query for custom report

Folks,

I need a SQL query to pull out last 24 hours failed job details [client name, Job id, Master server, status code, start time and end time] for SQL policy alone.  Also, total number of jobs ran for SQL policy, Success and failure count. Any help is appreciated.

Thanks

Bhasan