Topic
  • 7 replies
  • Latest Post - ‏2013-11-06T14:24:50Z by StephenCook
RK_AG
RK_AG
16 Posts

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

    Re: NCO_MAIL and Send mail

    ‏2011-09-16T11:40:12Z  
    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

    Re: NCO_MAIL and Send mail

    ‏2011-09-28T20:29:14Z  
    • Sammy1984
    • ‏2011-09-16T11:40:12Z
    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
    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

    Re: NCO_MAIL and Send mail

    ‏2013-02-05T17:05:29Z  
    • Sammy1984
    • ‏2011-09-16T11:40:12Z
    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
    very good document, thanks.
  • 5YXM_巴图_李
    5YXM_巴图_李
    1 Post

    Re: NCO_MAIL and Send mail

    ‏2013-06-08T09:42:39Z  
    very good document, thanks.

    the same

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

    Re: NCO_MAIL and Send mail

    ‏2013-10-08T07:02:56Z  

    Many Thanks for this attachment.

  • Jessedan
    Jessedan
    22 Posts

    Re: NCO_MAIL and Send mail

    ‏2013-11-05T18:13:28Z  

    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
    36 Posts

    Re: NCO_MAIL and Send mail

    ‏2013-11-06T14:24:50Z  
    • Jessedan
    • ‏2013-11-05T18:13:28Z

    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. 

    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