Post reply

Email Subscription and report back the result to table.

  • December 14, 2005 at 6:19 am

    #166261

    Hi everybody! I really need som help.

     

    I have a table that is being updated from a client applikation. When a new Row is added to this table Reporting services should send a report to users based on that table. The problem that I can't resolve is how do I check that the mail was sent? And how do i update the the new row that was added from the client with status "mailt sent".

     

    regards

     

    /Toby

     

     

     

     

     

  • December 14, 2005 at 8:04 am

    #609478

    In your ReportServer db, you can use Subscriptions table. In this table, check "LastStatus" and "LastRunTime" fields. Whenever a subscription executed, RS updates it here and it should say like "Mail sent to emailaddress@domain.com" or "Failure sending mail ..." with date/time stamp in LastRunTime field. You can determine your result base on "SENT" or "FAILURE" keywords.

    You can get report ID (i.e. "ItemID") from "Catalog" table by using "Name" field and than use that "ItemID" to join with "Report_OID" field in Subscription table to get that particular subscription record.

     

    Thats the way I do it.  I'm sure there might be other options for doing this, if anyone knows any other way to do it, please share.

    HTH

  • December 15, 2005 at 2:19 am

    #609656

    Thankz alot!

    I'll try that.

     

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

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