bsveritas
8 years agoLevel 1
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