Automic Workload Automation

Expand all | Collapse all

Anyone including part of 'Documentation' in email notification?

  • 1.  Anyone including part of 'Documentation' in email notification?

    Posted 07-29-2015 02:00 PM
    I would like to define a Notification to be used on job failure that includes information from the job documentation tab (AE v10).

    Either the first (1000?) characters from the job documentation, or the results from a search of the documentation field.

    Pretty sure this will involve some level of scripting in the process and post-process tab - any start or suggestion is appreciated.

    The actual documentation is in a BLOB field in the ODOC table (this is all in Oracle 11). 
    So a script could search for a link and extract it, maybe using the Oracle DBMS_LOB instr  and substr functions.  And then set an Automic variable to make that content available to the Notification object

    Local internal standards  require a link to an external (non-Automic) location for detailed job documentation
    -  Documentation / Docu holds a hotlink to general job documentation and detailed content only for Automic specific information.

    Including the hotlink in Failure related email would allow someone to read the documentation without opening the Automic UI.

    Other discussions in the Community appear to indicate that adding this type of content will require using sendmail or blat in a process/post process script.   Would prefer to use an Notification object to send the mail, and use the scripting to extract the data to pass to the script.

    COmments / suggestions / or OMG, an example?



  • 2.  Anyone including part of 'Documentation' in email notification?

    Posted 07-29-2015 02:03 PM
    We are already doing this.  One of our documentation tabs is "Recovery Documentation" and we include this in the email that goes out.  I'll go review my code and see what I can share.


  • 3.  Anyone including part of 'Documentation' in email notification?

    Posted 07-29-2015 02:12 PM
    Here is the piece of scripting we use to return a documentation tab into a variable;

    ! Captures RECOV Documentation
    :set &HandleXML# = xml_open(DOCU,"&DOCUOBJECT#","@Recov")
    :print HandleXML.Recov=&HandleXML#
    :if &HandleXML# = ""
    :   SET &RecovText# = ""
    :else
    :   SET &RecovText# = XML_GET_NODE_TEXT(&HandleXML#)
    :endif
    :xml_close

    As you can see the entire tab is returned as a single string, and thus runs into the variable size limit issue.  When the documentation won't fit into the variable the result is an empty string in which case we alter &RecovText# to say "Recovery documentation could not be loaded".  I believe V11 is supposed to fix this limitation. (We are V9 and looking at V11 right now.)


  • 4.  Anyone including part of 'Documentation' in email notification?

    Posted 07-29-2015 02:21 PM
    Thanks Pete!

    I will try your code out --- If I find a way to limit the output, I will share it back

    Regards
    Pat


  • 5.  Anyone including part of 'Documentation' in email notification?

    Posted 07-30-2015 11:13 AM

    Pete is right, I learned in an Automic Day some while ago that V11 won't have any more variable length limitations (wohoo).

    We have a similiar solution where we store escalation / operations relevant settings in the DOCU tab. However I suggest not to place the information there. At least out operations is impacted by irregular data amounts, downtimes/maintenance or temporarily changing handling instructions. I'm now going into a solution where a link is being created onto a Confluence Wiki page (based on the object name). There the operations relevant information is stored and can be changed without changing the AE object (think of change management ;-)). Also people can comment on it etc.

    Regards
    Joel