Report subscription hold

Is it possible to put a report subscription on hold, or pause the report, to prevent the report subscription from running in Report Manager?  The closest I can find is to edit the subscription and put in an end date and then go back in and remove it when you want it to run again.  We have regular maintenance windows where I don't want a report to run because there will be no data.

Because Subscriptions are run through the SQL Agent you should be able to just go to the database engine where the ReportServer database is on and disable the job temporarily that runs that subscription.

Wow.  It is amazing how obvious things are, once you know the answer.  Thanks.  Now I suppose the hard part is deciphering the GUID style job names that the server automatically gives to the jobs when you create a subscription.  But that I can do, one way or another.

Thanks,

I think some where in this article i have a query that will decode the GUIDs for you.

http://www.bidn.com/articles/reporting-services/110/monitoring-reporting-services-subscriptions

I was just compiling one for him myself. :)

SELECT 
	c.Name AS ReportName
	, rs.ScheduleID AS JOB_NAME
	, s.[Description]
	, s.LastStatus
	, s.LastRunTime
FROM 
	ReportServer..[Catalog] c 
	JOIN ReportServer..Subscriptions s ON c.ItemID = s.Report_OID 
    JOIN ReportServer..ReportSchedule rs ON c.ItemID = rs.ReportID
    AND rs.SubscriptionID = s.SubscriptionID

Thanks Brian and Devin.  These are both filled with great stuff.

This got me thinking about a few other problems I have had and some automated solutions to handling them.  My mind is racing.  Maybe I will write a blog or article when I get it all working.

Daniel