Store results from mail command

(4 posts) (2 voices)

Tags:

No tags yet.

  1. maron, Member

    Is there any way to access the results of the dbr.mail command - for storage in database for example. Currently it outputs to screen the result of the email. But accessing the smtp result would be very helpful.

    Maron
    (sorry this accidentally ended in the wrong forum)

    Posted 2 years ago #
  2. myDBR Team, Key Master

    There is none at the moment, but adding one would be easy if you need one.

    What do you want to store, the log (success / failure message)?

    --
    myDBR Team

    Posted 2 years ago #
  3. maron, Member

    Yes, the message with the failure / success codes would be good, as about 0.5% will be undeliverable.

    Posted 2 years ago #
  4. myDBR Team, Key Master

    Maron,
    update to newest build and you can use

    select 'dbr.mail.log.proc', 'sp_mail_log';

    The mail log procedure get's two parameters: the message and possible error message.

    create table mail_log (
    sent_at datetime,
    message varchar(255),
    error text null,
    primary key(sent_at)
    ); create procedure sp_mail_log (
    in_msg varchar(255),
    in_error text
    )
    begin insert into mail_log(sent_at, message, error)
    values ( now(), in_msg, in_error ); end

    --
    myDBR Team

    Posted 2 years ago #

Reply

You must log in to post.