Post reply

verify subscription email sent

  • September 4, 2009 at 2:58 pm

    #225851

    In RS 2005, how can you verify, via code or logging or whatnot, that an email was actually sent when a subscription executes?

    A verifying subscription successfully executed is not the same as verifying that the email was sent.

    I need log/track that email were successfully sent.

    Anybody know how to do this?

    thanks

  • September 7, 2009 at 1:32 am

    #1050003

    Use subscriptions table

    select * from subscriptions

    select LastStatus from subscriptions

    LastStatus column contains the status of mail send through subscription

    If want write a trigger on it and track the status

    -----------------------------------------------------------------------------------------------------------------------------------------------------------
    Please feel free to let me know if you are not clear or I’ve misunderstood anything.

    Thanks,
    Arunkumar S P

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply