# Find which SSRS reports are associated with SQL Job GUIDs

**URL:** https://forum.innovativeusers.org/t/find-which-ssrs-reports-are-associated-with-sql-job-guids/2640
**Category:** Polaris Repository
**Created:** [September 26, 2025, 7:22pm UTC](https://forum.innovativeusers.org/t/find-which-ssrs-reports-are-associated-with-sql-job-guids/2640 "2025-09-26T19:22:52Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![wesochuck](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/wesochuck/32/499_2.png) [@wesochuck](https://forum.innovativeusers.org/u/wesochuck)
#### Post date: [September 26, 2025, 7:22pm UTC](https://forum.innovativeusers.org/t/find-which-ssrs-reports-are-associated-with-sql-job-guids/2640/1 "2025-09-26T19:22:52Z")

</div>

Your report server database ([which may or may not be on the same server as your other Polaris database](https://forum.innovativeusers.org/t/query-ssrs-report-execution-log/2492/3)), creates SQL jobs to run any schedule SSRS reports, you can see the GUIDs for those here:

 ![image](https://forum.innovativeusers.org/uploads/db7787/original/2X/7/77d093f3d10b1adbc99aecbc95c700aa5540dd64.png)

If you’d like to see which schedules and which reports are associated with those GUIDs you can run the following SQL. IT **MUST BE RUN THE SERVER THAT HOLDS YOUR SSRS DATABASE**.

```sql
SELECT 
    sj.[name] AS [SQL_Job_Name],
    su.SubscriptionID,
    su.Description AS [Subscription_Description],
    c.[Name] AS [Report_Name],
    c.[Path] AS [Report_Path],
    su.LastRunTime,
    su.LastStatus
FROM msdb.dbo.sysjobs AS sj
INNER JOIN ReportServer.dbo.ReportSchedule AS rs 
    ON sj.[name] = CAST(rs.ScheduleID AS NVARCHAR(128))
INNER JOIN ReportServer.dbo.Subscriptions AS su 
    ON rs.SubscriptionID = su.SubscriptionID
INNER JOIN ReportServer.dbo.[Catalog] AS c 
    ON su.Report_OID = c.ItemID;

```

* * *

To see which jobs have been running recently, follow these instructions: [Query SSRS Report Execution Log](https://forum.innovativeusers.org/t/query-ssrs-report-execution-log/2492)