Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Ken Blum
Constraint Violating Yak Guru
383 Posts |
 Posted - 2010-01-25 : 09:54:39
|
| I have an SSRS report that I have setup multiple subscriptions. This results in a SQL Agent Job being created for each subscription which is named based on the subscription guid ID. I setup my own job, named "POS SSRS Emails", and created a separate step in this job for each subscription, copying the step from each of the original individual subscription jobs. I then deleted all of the subscription jobs. The POS SSRS Emails job runs as expected, sending emails of the report as desired.I know that if I change the subscription in any way, I need to delete the jsubscription ob that is automatically created again. However, I have found that it is automatically re-creating the jobs at some point, without me even going into the subscription. Does anyone know how to prevent this from happening?I just setup each schedule in the subscription so the schedule terminates on 1/19/2010. I then deleted all of the subscriptions again. Perhaps that will resolve it? My "POS SSRS EMails" job will still run, but now I wonder if the step call to the report will still run. Here is the step call...exec ReportServer$WDGDBRSQL001_2K8.dbo.AddEvent @EventType='TimedSubscription', @EventData='5d44e1ae-187b-454e-a11e-efd3ea8e7cd9'TIA, Ken |
|
|
|
|
|
SQL Agent Subscription Jobs