How to identify report server jobs

  • Hi we have various report server jobs schedule on our sql server.I can determine what are this jobs doing as they donot have name numbers.

    Is there any way to determine what report sever jobs are doing.

    Is there any way to query sql server report database to gathere information about this report server jobs

  • You can pick and choose columns from it. From here you can see the Report name as well as the job name so you can tie the two back together. Not sure if this is what you need though.

    SELECT *

    FROM ReportServer..Catalog cat

    INNER JOIN ReportServer..Subscriptions sub on cat.ItemID = sub.Report_OID

    INNER JOIN ReportServer..ReportSchedule rs on cat.ItemID = rs.ReportID

    and sub.SubscriptionID = rs.SubscriptionID



    Everything is awesome!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply