Opscenter SQL query for oracle and SQL Job Instance and Client name

Please provide with Opscenter SQL query for oracle and SQL Job Instance and Client name

Client-name

Job-Instance

Status code

Start Date and Time

End Date and Time