• i have a job scheduled on each server that contains a reportserver database that updates the job description with the report name, so it's much easier to track down that the job named "someguid" is actually SSRS Report Subscription: /Departments/Information Technology/Public/Some Technical Report

    that metadata to build the command is surprisingly simple:
    SELECT
         'UPDATE msdb.dbo.sysjobs set description = ''SSRS Report Subscription: '
         + e.path COLLATE SQL_Latin1_General_CP1_CI_AS + Char(13) + Char(10) + e.NAME COLLATE SQL_Latin1_General_CP1_CI_AS + ''' WHERE job_id = ''' + CONVERT(VARCHAR(40), b.job_id) + ''';' AS Fix
         FROM dbo.ReportSchedule a
           INNER JOIN msdb.dbo.sysjobs b
              ON CONVERT(VARCHAR(40), a.ScheduleID) = b.NAME
           INNER JOIN dbo.ReportSchedule c
              ON b.NAME = CONVERT(VARCHAR(40), c.ScheduleID)
           INNER JOIN dbo.Subscriptions d
              ON c.SubscriptionID = d.SubscriptionID
           INNER JOIN dbo.Catalog e
              ON d.report_oid = e.itemid

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!