Post reply

Schedualed Report Delivery

  • February 19, 2009 at 1:29 pm

    #383976

    Hi Guys,

    I want my one Scheduled Report should be sent if it does not have any data. Instead of that i a mail should be sent to concerned person. Anyone has work on anything like this ?

    Thanks in advance.

    Hary

    Thanks a lot,
    Hary

  • February 20, 2009 at 6:20 am

    #947442

    Scheduled reports work by creating a SQL Server Agent job on the Report Server. You can schedule a report so the job gets created, but never runs because the scheduled date is already past. Then you can create a second SQL Server Agent job that runs a an IF EXISTS query to check for data that would be on the report and if data exists use the sp_start_job (see BOL for details) procedure to call the job created by Reporting Services.

    It is not an ideal situation, but it is the only way I know of to do what you want.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • June 5, 2009 at 5:14 am

    #1005151

    Thanks a lot Jack , It worked for me.

    Hary

    Thanks a lot,
    Hary

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

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