ESP dSeries Workload Automation

 View Only
Expand all | Collapse all

Can list of applications or events be extracted as text

  • 1.  Can list of applications or events be extracted as text

    Posted Nov 18, 2022 01:58 PM
    Hello,

    We sometimes get requests from our application support groups asking for a list of their dSeries applications or events.  While the list of these is easy to pull up based on our naming convention, we tend to end up doing screen shots to get them that information.  Ideally we'd like to be able to provide that information as a text file which would allow them to more easily copy and paste the names when the contact us for changes.

    Is there any way to extract the list of events or applications in a text format?

    Thanks,
    Donna Domovic


  • 2.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Nov 21, 2022 06:54 AM
    Hi,

    jobmap cli command should be helpful here. It gives information at job level as well. The output can be saved in a text file.
    You can filter out what you want to display based on the DISPLAYFIELDS and NODISPLAYFIELDS options below.

    -> help jobmap
    Usage:
    JOBMAP EVENTS("events") [JOBS("jobs")] [SCHEDULECRITERIA("schedulecriteria")] [DISPLAYFIELDS("displayfields")] [NODISPLAYFIELDS("nodisplayfields")]

    Display jobmap information including the last run of a job.
    Example:
    jobmap events("SCHEDMASTER.VERIFY")
    jobmap events("*")
    jobmap events("SCHEDMASTER.VERIFY") jobs("WIN*")
    jobmap events("SCHEDMASTER.VERIFY") schedulecriteria("friday")
    jobmap events("SCHEDMASTER.VERIFY") DisplayFields("SUCC,PRED")
    jobmap events("SCHEDMASTER.VERIFY") NoDisplayFields("SUCC")

    events <string>
    The Event name. If not specified, all Events details are listed. Wildcard characters are permitted. * represents any string of zero or more characters. ? represents any single character.
    Sequence of characters matching regular expression "[\p{L}\p{N}@$_\.\*\?]*".

    jobs <string>
    The job name(s). If not specified, all jobs details are listed. Wildcard characters are permitted. * represents any string of zero or more characters. ? represents any single character.
    Sequence of characters matching regular expression "[\p{L}\p{N}@$_\.\*\?]*".

    schedulecriteria <string>
    The schedule statement.

    displayfields <string>
    A comma separated field list to display in the output.

    nodisplayfields <string>
    A comma separated field list to skip in the output.

    Hope it helps!
    Ravi Kiran


  • 3.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Nov 21, 2022 08:47 AM
    Hi,
    In addition to job JOBMAP, you can also use LISTEVENT in CLI just to see all your events.  Type HELP LISTEVENT to get more details.

    HTH,
    Nitin Pande

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 4.  RE: Can list of applications or events be extracted as text

    Posted Nov 21, 2022 09:51 PM
    Ravi and Nitin,

    Thanks for the quick response.  We'll play around with the 2 options you suggested.  

    One follow up question on the JOBMAP option.  In the example, I see you list SUCC,PRED and fields. 

    Is there some place where I can find a list the various field names that can be used in that parameter or other places field names are listed?

    Thanks,
    Donna Domovic


  • 5.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Nov 22, 2022 10:31 AM
    Hi Donna,
    Please see this link for all Jobmap keywords.  Here is the link for Jobmap documentation for your reference as well.

    HTH,
    Nitin Pande
    Broadcom

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 6.  RE: Can list of applications or events be extracted as text

    Posted Apr 12, 2024 10:26 AM

    JOBMAP EVENTS("events") [JOBS("jobs")] [SCHEDULECRITERIA("schedulecriteria")]

    do you have documentation that describes all the schedulecriteria syntax with examples?

    thanks!




  • 7.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Apr 12, 2024 10:39 AM

    Here is the doc link for JOBMAP for all the keywords that are supported.  See here for examples.



    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 8.  RE: Can list of applications or events be extracted as text

    Posted Apr 24, 2024 07:16 AM

    Is JOBMAP supposed to report on all jobs in an application?
    I've run it for an application with twelve monthly jobs and it only reports on the job that is going to run in the upcoming month.
    I had expected it to provide a list of all the monthly jobs in the application.




  • 9.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Apr 24, 2024 12:46 PM

    HI,

    You can define events in the jobmap to filter out the jobs for particular application.  

    JOBMAP EVENTS("events") [JOBS("jobs")]

    You can define REGEX / wildcard for events to see all the jobs in all the application.

    HTH,

    Nitin Pande



    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 10.  RE: Can list of applications or events be extracted as text

    Posted Apr 24, 2024 02:39 PM
    jobmap events("SS_IBM*") jobs("*")
    and it only displays one job..the one that it's going to execute next month. there are 11 other monthly jobs that are not
    displayed.
    Am I using regex correctly? If it's incorrect, do you have a working example with Regex and jobmap?  I did a search
    for REGEX in the document and could not find an example with jobmap events wildcard you mentioned.
    Thanks for your assistance.
     
    Event Name:SS_IBM.SS_IBM_SUB_CAPACITY_REPORTING
    -----------------------------------------------------------
     Application Name:SS_IBM_SUB_CAPACITY_REPORTING
    ===========================================================
      Anticipated End Time:10:44:22 Fri 3 May 2024
      Agent Name:PROD_SCHEDULER
      Execution Time(min):44.366665
      Event Schedule:3rd weekday at 10AM
      
    ***********************************************************
        Job Name:FSPSCR05
        Job Type:ZOS
        Data Set Name:FTS.MAINT.JCLLIB
        CCCHK:CCCHK1(RC(4) OK CONTINUE)
        Run Schedule:may
        Auto-Resubmit failed job:RetryCount(0) RetryInterval(0) RetryCondition("") 
        User Name:ftsmstr
        Life Time(min):44.4
        Anticipated End Time:10:44:22 Fri 3 May 2024
        Agent Name:MF_PROD
        Notification Email:Notify1(.........
        Execution Time(min):44.366665
        z/OS User ID:xxxxmstr
        Anticipated Start Time:10:00:00 Fri 3 May 2024



  • 11.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Apr 26, 2024 01:23 AM

    Looking at the above , regex looks good. Is there any day where all your jobs will run. If so , can you give that in the schedule() parameter.

    If you don't specify anything it will list the jobs for the next execution time only.  In your case the event is scheduled at 3rd weekday at 10AM. So it is listing the jobs on that day.

    So if you want all jobs , you can give the schedule where all your jobs will run.

    Hope it helps!

    Ravi Kiran




  • 12.  RE: Can list of applications or events be extracted as text

    Posted Apr 29, 2024 02:19 PM

    Thanks for your help and confirming my understanding of how JOBMAP works!




  • 13.  RE: Can list of applications or events be extracted as text

    Posted Apr 26, 2024 08:05 AM

    Hello,

    This seems to be more a simulation with variables translated rather than listing of job definitions which would include untranslated  variables.  We use a lot of variables in our applications and job definitions and it's important App Teams have an easy way to verify the jobs are set up correctly with the correct variables.  What we're looking for is some way to display the job definitions for all jobs, regardless of when they run, with the variable names.

    Is there any command or way to get that information in text form?

    Thanks,

    Donna Domovic




  • 14.  RE: Can list of applications or events be extracted as text

    Broadcom Employee
    Posted Apr 30, 2024 07:26 AM

    Can you please check if the FindJob utility in Desktop Client in Define perspective helps.




  • 15.  RE: Can list of applications or events be extracted as text

    Posted Apr 30, 2024 03:47 PM

    This might be what you are looking for-

    In Define, Right mouse click on the application name and click Save As.
    You can save the application as an XML text file and open as a readonly workbook into Excel for viewing and cut and paste.
    the jobnames UNIX,Mainframe,tasks and links in the spreadsheet should be in these columns when you open the xml file in excel
    name                        column N

    /dst_job/@name N
    /link/@name BE
    /task/@name DE
    /unix_job/@name DS
    /zos_job/@name GV