We are running a SQL Server 2014 database using SSRS as a reporting tool. We have data coming in via SSIS jobs and linked servers. We have developers creating various SSRS jobs and scheduling them.
I am wondering if anyone has any recommendations on how to document all the jobs in the Job Activity monitor. My goal is to identify the SSIS jobs as well as the SSRS scheduled reports. I'd like to know what tables the SSRS jobs hit so I can make sure they are scheduled after any tables they hit are updated. Does anyone have a tool or a way they have created this documentation? I have become the accidental DBA in my group so any guidance would be appreciated.