Fire SSRS Subscriptions Manually

This is a simple user guide on how you can fire SSRS Subscriptions manually. Please follow the steps provided below.

1. Open the Failing SSRS Subscriptions.csv (I have previously configured tables that monitor my SSRS Subscriptions and Reports' SQL)

2. Choose the subscriptions you want to fire

3. Choose the subscriptions you want to fire – Manage -> Subscriptions

4. Edit the failed subscription

5. In the URL you would find SubscriptionID

In this instance it’s 950630eb-0418-4f2c-8245-89b98803a942

NB! You can alternatively find the subscription ID from the excel file. The column that provides you with this information is Subscription id, you would only need to strip it out of the curly brackets {}!

6. Open SSMS and connect to your Server.

7. Use ReportServer database and the following scripts

--Find schedule ID

SELECT ScheduleID
FROM ReportSchedule  
WHERE (SubscriptionID = '950630eb-0418-4f2c-8245-89b98803a942')

Use the SSRS Subscription id in the Where clause in order to find the schedule id. The Schedule ID can be used to identify your subscription in the agent manager.

Copy the SubscriptionID and use it in the next script in the @EventData parameter.

EXEC ReportServer.dbo.AddEvent @EventType='TimedSubscription', 
@EventData='950630eb-0418-4f2c-8245-89b98803a942'

Run the script and you should have your Subscription fired.

Check your email to confirm it has worked and enjoy. 😊