Guidelines to troubleshooting and documenting SQL Server SSRS

A while back I got a question about how to document SQL Server Reporting Services.

I have been very busy, but here is a short post on the subject.


How to find SQL Server agent jobs related to a database

When migrating a database to a new SQL Server instance, there are numerous steps to be taken, as I mention here.

One of the considerations is to move all Agent Jobs related to the database to the new instance.

How do we find which jobs to move, though?