dependency jobs on sql server

Question

Hi Expert,

How to find the dependent jobs in sql server database, I found below method .any other methods to be check to check any other server or SQL database from any other Server machine has any dependency or any ssis or any other jobs dependency

https://learn.microsoft.com/en-us/sql/relational-databases/tables/view-the-dependencies-of-a-table?view=sql-server-ver15

Shree

Answer 1

I think you will need to look through all these jobs to see what they do. You probably need to talk with people in the application teams to get knowledge, as figuring everything out on your own is difficult.

My first thought would be that jobs on different servers are largely independent of each other, but there can of course be jobs on one server that extracts data which is to be loaded from a job on a different server.

Whether you can migrate jobs 20 days in advance? If you can make sure that on one changes the jobs during this period, I guess you could.