AppWorx, Dollar Universe and Sysload Community

Expand all | Collapse all

Query all planned jobs

  • 1.  Query all planned jobs

    Posted 09-15-2020 11:07 AM
    how to query, directly from the database, all planed jobs with start date/time which are planned and activ for the current year?


  • 2.  RE: Query all planned jobs

    Posted 09-16-2020 08:40 AM
    This can get you started. It is an old query, and i have not used it recently. I know tables are moving to xml format, so this may be out dated. It is only getting chains/processes, it is not getting Jobs. 



    -------------------------------------------------------------
    -- Processes with an active schedule with either a blank agent
    -- or blank requestor.
    -------------------------------------------------------------
      SELECT a.so_module        "Process",
             b.aw_sch_name      "Schedule Name",
             b.aw_agent_seq     "Agent",
             c.so_user_name     "Requestor Name",
             c.so_db_login      "Requestor Login"
        FROM appworx.so_job_table   a,
             appworx.aw_module_sched b,
             appworx.so_user_table  c
       WHERE     a.so_command_type = 'CHAIN'
             AND a.so_job_seq = b.aw_job_seq
             AND b.aw_active = 'Y'
             AND (b.aw_agent_seq IS NULL OR b.aw_user_seq IS NULL)
             AND (b.aw_user_seq = c.so_user_seq)
    ORDER BY a.so_module;
    ------------------------------------------------
    Christopher J. Mills
    Assistant Director
    Administrative Computing
    Binghamton University
    Binghamton NY, 13902-6000
    607-777-6832
    http://www2.binghamton.edu/