Hi Team,

On my development, test and production SQL server, there are tables/stored procedures/functions, tables, SSIS jobs pointing to SSIS packages. 

From those, I need to delete unwanted things. Can someone help me to find out best way to this done. I would like to know query to get this done.

For example, query to get the details like who has created job and which package it is referring instead of doing manual check.

Any advice on this point will help me.

Thanks