Post reply

is it possible to disable the SSRS subscription when SQL Agent job fails

  • November 12, 2010 at 4:01 am

    #241087

    Hi Folks,

    My question is it possible to disable the SSRS subscription when SQL Agent job fails.

    Scenario:

    i have created 4 subscription in SSRS and scheduled to run daily morning @6AM . i have created the SQL Agent job also callde BI_AR it executes the SSIS package and populate the tables relevant to the subscription. suppose today this BI_AR job failed means no record will populate in the tables for today. but as per the schedule time the subscription will enable and send the mail to the concern users along with the wrong data . so for this reason i need to stop running the subscription.

    if anybody knows kindly send me the steps how to impelement this logic to disable the subscription.

    Can anybody help me on this requirement. its very urgent for me .

    Regards,

    Sabarinathan

  • November 19, 2010 at 12:25 pm

    #1253266

    How about implementing a data-driven subscription then?

    If I understand your question right, you'll just have to use an appropriate query in Step 3 and then use its field as you need while creating a subscription.

    Hope it helps

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

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