Schedualed Report Delivery

  • 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

  • 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.

  • 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