Automic Workload Automation

Expand all | Collapse all

How to attach only REP report in email notifcation and to get batch date

  • 1.  How to attach only REP report in email notifcation and to get batch date

    Posted Mar 15, 2018 12:15 AM
    Hello
    I'm a new user to UC4 and I would appreciate some help with the following:

    I would like to be email notified when any of the jobs in a workflow fail and I have implemented it. But it has to be customized.

    1. For email attachments I'm using the option "Attach reports from Task (RunID)" in Notification tab and I'm receiving both ".ACT.txt" and ".REP.txt". 
    But only ".REP.txt" file is required. How can it be achieved?

    2. Notification email  contains below information

    Object:  
    Run#:  
    Parent: 
    Batch Date: --> It is currently set to SYS_LDATE("HH:MM:SS"). But it should be batch run date. 
    For instance, if I run the workflow for 01 Jan 2018 then the Batch Date should also be the same in email. 

    Thank you in advance


  • 2.  How to attach only REP report in email notifcation and to get batch date

    Posted Mar 15, 2018 03:56 AM
    Hi Revathi_Chelladurai_10523

    Many thanks for your request and questions.
    Have a look at this topic in the community. That might help you implement what you want.

    Should you have any further questions or queries, feel free to contact me anytime.

    Cheers
    Daniel


  • 3.  How to attach only REP report in email notifcation and to get batch date
    Best Answer

    Posted Mar 15, 2018 04:27 AM
    Hi Revathi,

    I think GET_STATISTIC_DETAIL() is what you're looking for. This will give you activation, start or end date and time. You have to pass the RUNID and an arguments that specifies which information you would like to retrieve.

    Here's an example on how to retrieve the start time
    :SET &STARTTIME# = GET_STATISTIC_DETAIL(<runid>, START_TIME)

    Regarding the report question. I'm currently not aware of an easy way to only retrieve the report. As long as the Job has an Activation Report it will also give you the ACT.txt file.

    Maybe someone else knows an easy solution.

    Matthias


  • 4.  How to attach only REP report in email notifcation and to get batch date

    Posted Mar 15, 2018 01:37 PM
    @Matthias Schelp
    Thank you. This has helped.