Home Forums Reporting Services Reporting Services Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent RE: Subscriptions from Reporting Services get unintelligable job names in SQL Server Agent

  • It looks like the sqlagent job name is the guid actually used for the schedule stored within the database.  Since the app (i.e. RS itself) will be relying on this, you can't chnge this. 

    But, you could use a view like below to produce a quick reference of what each guid (sql agent job) is doing.   Note that because you're going directly against the app tables, these fields (types, names, relationships etc etc) could change in the future with no requirement on m$ft to inform anyone.  ie if you do a sp upgrade and this stops working, chances are they changed something

    SELECT     Schedule.ScheduleID AS SQLAgent_Job_Name, Subscriptions.Description AS sub_desc, Subscriptions.DeliveryExtension AS sub_delExt,

                          [Catalog].Name AS ReportName, [Catalog].Path AS ReportPath

    FROM         ReportSchedule INNER JOIN

                          Schedule ON ReportSchedule.ScheduleID = Schedule.ScheduleID INNER JOIN

                          Subscriptions ON ReportSchedule.SubscriptionID = Subscriptions.SubscriptionID INNER JOIN

                          [Catalog] ON ReportSchedule.ReportID = [Catalog].ItemID AND Subscriptions.Report_OID = [Catalog].ItemID

     

    cheers,

    Steve.