How to Setup Schedule On SSRS on Time Basis?

Hi All,

I am new to SSRS. I subscribe my report through report subscription. I want to schedule my report from 9 AM to 17:30 PM. I setup start time but I am not able to schedule to stop at 17:30 on daily basis.

Please help me ....

Thank you in advance....

Regards,

Balwant Patel.

I don't think this level of flexibility is supported. I'd use the FireEvent API to kick off the schedule programatically.|||

Hi Teo,

I have no idea about FireEvent...I will look on FireEvent but the time being..i schedule the same report twice.

sql

How to send report through email one time i.e. without subscription for recurrent emailing?

I want to send a deployed report (report manager), through email, by calling reportingServices webservice. But the requirement is that, time is not fixed for sending this email, so I want to trigger the sending of report as a one time event, no subscription to a daily time...

How should I go about it?

Hello,

As I see it you have two choices, you could either create a one time subscription on the fly (http://technet.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.createsubscription.aspx) or a create a Delivery Extension (http://technet.microsoft.com/en-us/library/ms154050.aspx) that has email as the delivery method. The first option is the easiest and most straight forward. Create a new subscription with a schedule to run the report one time at a time 5 minutes from then.

Good luck,

Larry