Automic Workload Automation

  • 1.  Need SQL query to find modified schedule tasks

    Posted Jan 03, 2017 01:33 PM
    Hello Automic community!

    I'm looking for a SQL query (for v9) that will allow me to identify tasks within a schedule that have been modified (e.g., have that little clock-with-a-pencil icon).  We're hoping to turn this into a daily report we can review to identify any modified (active) schedules that we may have forgotten to reload at turnaround.

    I suspect this query is pretty simple...I just haven't been able to pinpoint which table houses the active schedule content.  (I know JPP houses the schedule content, but I can't find the corresponding table for the active schedules.

    Thanks for any help!


  • 2.  Need SQL query to find modified schedule tasks

    Posted Jan 06, 2017 01:51 AM

    You can try EJPP table



  • 3.  Need SQL query to find modified schedule tasks

    Posted Jan 06, 2017 10:54 AM
    Hi daryl.brown_ACI  - by "schedule" did you mean JSCH (Schedule) or JOBP (workflow) ? 

    If workflow, Surawadee_Tangtorkit_1865 is correct. EJPP holds the active workflows (present in the Activity window).
     



  • 4.  Need SQL query to find modified schedule tasks

    Posted Jan 06, 2017 10:56 AM
    No, I was actually referring to the JSCH schedule objects.


  • 5.  Need SQL query to find modified schedule tasks

    Posted Jan 06, 2017 06:15 PM
    Hi Daryl,

    Ok so for JSCH, it should also be in EJPP.
    Look for ejpp_modflag = 1 (tasks inside a JSCH that were modified - can be seen in the Monitor).