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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2013-04-17 : 12:09:09
|
| hi all,As everyone knows, RS jobs are assigned a job name such as 027EDDD3-BB41-4F65-BD66-60265311250F which is almost meaningless to us humans.1. Is there a way to assign a better name when you create the report?2. Is there a way of listing these jobs to cross-reference them to the actual Report Title?Thanks for any ideas. Jack |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-18 : 03:03:54
|
| are you asking about jobs created through subscriptions?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2013-04-25 : 09:34:08
|
| Thanks visakh16.Yes I believe these were created through subscriptions.The is the job step for an example:exec [ReportServer].dbo.AddEvent @EventType='TimedSubscription', @EventData='51c59deb-e1ef-403d-b7a1-0004fbb4b7ee'How can I determine which report title this job actually produces, without actually running the job?Thanks, Jack |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-04-25 : 12:28:17
|
| Have a look at report catalog tables in reportserverdb------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
Reporting Services Job Names