import java.sql.*;
import java.io.*;

public class GetOracleJobs {
    public static void main(String[] args) throws Exception {
        Class.forName("oracle.jdbc.driver.OracleDriver");
        Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:test", "test_user", "test_pass");

        Statement stmt = conn.createStatement();
        ResultSet rs = stmt.executeQuery("select job, what, interval, last_date, next_date, failures from dba_jobs where log_user = 'TEST_USER'");
        while (rs.next()) {
            print("[" + rs.getString(1) + "]");
            print(rs.getString(2));
            print("interval: " + rs.getString(2));
            print("last_date: " + rs.getString(3));
            print("next_date: " + rs.getString(4));
            print("failures: " + rs.getString(5));
            print("");
        }
    }

    private static void print(String s) {
        System.out.println(s);
    }
}