Automic Workload Automation

  • Private Community
Back to discussions
Expand all | Collapse all

EVNT.DB: Setting the SQL agent by using :PUT_ATT HOST does not work?

  • 1.  EVNT.DB: Setting the SQL agent by using :PUT_ATT HOST does not work?

    Posted Apr 24, 2019 05:20 AM

    Hi,

     

    we are currently looking at the DB event (EVNT.DB). We noticed that we cannot set the SQL agent in the script using ":PUT_ATT HOST=...". According to the documentation, a host group cannot be used. A script variable in the agent field works. We are currently still using version 11.2.


    What are your experiences?

    Does someone use ":PUT_ATT HOST=..." for the DB event with a newer version?

    Can you think of a reason why this shouldn't work?

     

    Best regards

    Tim



  • 2.  Re: EVNT.DB: Setting the SQL agent by using :PUT_ATT HOST does not work?

    Posted Apr 24, 2019 08:41 AM

    Ahoi,

     

    some colleagues do use EVNT.DB's but as there can be used 2 Agents for the comparison the syntax seems to be:

     

    :    PUT_ATT OPERAND1_SQL_AGENT = "MYSUPERDUPERORACLEAGENT"
    :    PUT_ATT OPERAND2_SQL_AGENT = "MYSUPERDUPERMSACCESSAGENT"

     

     

    in general - to obtain an agent from a HOSTG we use PREP_PROCESS_AGENTGROUP

     

    cheers, Wolfgang