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 |
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
 Posted - 2010-05-25 : 15:21:44
|
| I have set up some subscriptions for some reports, when the job is created in SQL Server Agent I changed the names to something readable instead of the long GUID created. However, it seems every time I run the subscriptions, it automatically recreates these jobs, is there anyway around this? |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2010-06-01 : 09:26:12
|
| Don't change those long guid strings that are used for the subscription names. You will cause problems with report services. There are some good videos on www.sqlshare.com, on various facets of reporting services and report manager. There is one that touches on this exact topic.______________________________________________Talk sense to a fool and he calls you foolish. |
 |
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-07-21 : 14:30:57
|
| Hey savior faire (shouldn't it be savoir faire?), I am not changing the subscription names, just renaming the jobs that run the subscriptions, and it works no problem, however the ugly GUID jobs keep getting recreated. |
|
|
|
andrewhopkinson
Yak Posting Veteran
63 Posts |
Posted - 2010-07-23 : 16:12:28
|
| Well, I created a script to delete the unused jobs and I think that caused problems as you say. Naming the jobs based on GUIDs doesn't make sense to me since these are unique across servers, which means you can't a solution to run these jobs that will apply to multiple servers. Bizarre. |
|
|
|
|
|
|
Subscription auto job creation