Topic
IC4NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
7 replies Latest Post - ‏2013-11-06T14:24:50Z by StephenCook
RK_AG
RK_AG
16 Posts
ACCEPTED ANSWER

Pinned topic NCO_MAIL and Send mail

‏2011-09-14T17:31:06Z |
We have installed Omnibus 7.3.0 on AIX and want to configure NCO_MAIL utility. I have edited sendmail procedure to use the utility. But not able to send emails. Do we have any technote or guide to follow on nco_mail or sendmail. Do i need to configure anything before editing the procedure?/
Updated on 2013-02-05T17:05:29Z at 2013-02-05T17:05:29Z by SystemAdmin
  • Sammy1984
    Sammy1984
    46 Posts
    ACCEPTED ANSWER

    Re: NCO_MAIL and Send mail

    ‏2011-09-16T11:40:12Z  in response to RK_AG
    I am not sure about AIX. I followed the steps in the attached document on Linux platform.

    Also make sure that Omnibus server details are configured on SMTP server to send and receive emails.

    Hope it helps.

    -Ravi
    • ken_cottrell
      ken_cottrell
      23 Posts
      ACCEPTED ANSWER

      Re: NCO_MAIL and Send mail

      ‏2011-09-28T20:29:14Z  in response to Sammy1984
      Thank you for this .doc !! It allowed me to figure out what was wrong with my external procedure/trigger. Now we just need to figure out how to get this added to the online Omnibus Documentation.
    • SystemAdmin
      SystemAdmin
      1283 Posts
      ACCEPTED ANSWER

      Re: NCO_MAIL and Send mail

      ‏2013-02-05T17:05:29Z  in response to Sammy1984
      very good document, thanks.
      • 5YXM_巴图_李
        5YXM_巴图_李
        1 Post
        ACCEPTED ANSWER

        Re: NCO_MAIL and Send mail

        ‏2013-06-08T09:42:39Z  in response to SystemAdmin

        the same

        Updated on 2013-06-08T09:44:01Z at 2013-06-08T09:44:01Z by 5YXM_巴图_李
  • AbdelRaheemHamed
    AbdelRaheemHamed
    3 Posts
    ACCEPTED ANSWER

    Re: NCO_MAIL and Send mail

    ‏2013-10-08T07:02:56Z  in response to RK_AG

    Many Thanks for this attachment.

  • Jessedan
    Jessedan
    21 Posts
    ACCEPTED ANSWER

    Re: NCO_MAIL and Send mail

    ‏2013-11-05T18:13:28Z  in response to RK_AG

    This looks great. I'm also planning to setup an email that will monitor the total counts of alarms. Anyone of you knows how to do it? This will be my evaluate part  - select count(*) from alerts.status; and my problem now is the action tab for the trigger. 

    • StephenCook
      StephenCook
      35 Posts
      ACCEPTED ANSWER

      Re: NCO_MAIL and Send mail

      ‏2013-11-06T14:24:50Z  in response to Jessedan

      Hi

       

      Try something like this

      create or replace trigger evtcntmai

      group default_triggers

      priority 19

      every 5 minutes

      declare

      rc int;

      begin

      -- count the number of rows in alerts.status

      for each row tt in alerts.status

      begin

      set rc = rc + 1;

      end;

      -- send some one an email with the current event count

      execute procedure send_email( 'Total event count = ' + to_char(rc), ..... );

      end;

       

      A couple of notes, you will see there is no evaluate clause in this trigger the for each row mechanism used here is more efficient than putting the query in the evaluate clause, the performance trouble shooting section of the docs has some information on that.

      Secondly you will need to put the correct parameters in to the send_email procedure.

       

      Cheers

      Steve