dependency jobs on sql server

Shri 21 Reputation points
2020-11-14T23:10:26.873+00:00

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

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,690 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
494 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.9K Reputation points MVP
    2020-11-15T13:24:30.403+00:00

    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.

    0 comments