1 Reply Latest reply on May 13, 2019 10:13 AM by gautham marathu

    working on a rulepoint, to get alert every 15 mins that rulepoint is UP- Not working

    gautham marathu New Member

      i put

       

      SELECT 1  AS STATUS FROM DUAL WHERE SYSDATE  > TO_DATE ( <<tstamp>>,'yyyy-mm-dd hh24:mi:ss')  in source connection,

       

      in topic i put only STATUS as column

       

      i have power center responder

       

      here is my query,

       

      when 1 PMPC_Connection_Availability  t0

      then "PowerCenter Notification Response" with topic = " PMPC_Connection_Availability  as PMPC_Connection_Availability" , properties = "*", params = "body = PMPC_IS_UP_AND_RUNNING  , subject = PMPC_IS_UP_AND_RUNNING. , persona = pcmonitor, priority = 3,  channels = c_PMPM_AVAILABILITY, rulename = ${drql_rulename},  delivery = default, snooze = 0, product = Operations, rule_group = O3 Execution failures, rule_user = OPS_USER"