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