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 |
|
ipisors
Starting Member
39 Posts |
 Posted - 2015-04-21 : 15:56:34
|
| I've used the advice here:http://www.mssqltips.com/sqlservertip/1846/how-to-easily-identify-a-scheduled-sql-server-reporting-services-report/to try to identify which GUID in sql server agent is running my ssrs subscription. I get the error, "conversion failed when converting from a character string to uniqueidentifier", which someone said they solved by "Convert a.ScheduleID and C.ScheduleID to varchar for a proper join". But when I use "convert(varchar,a.ScheduleID)" and "convert(varchar,c.ScheduleID)", I get "Insufficient result space to convert uniqueidentifier value to char.".Does anyone know how to identify my subscription sql server agent? I need to modify the transact sql in the sql server agent step to exit early if there are no records.And yes I already know about data driven subscriptions, can't do that now. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ipisors
Starting Member
39 Posts |
Posted - 2015-04-21 : 16:12:44
|
| <sigh> ... When will I learn?THANKS! |
 |
|
|
|
|
|
identifying GUID in sql agent for SSRS subscriptio