How to get SSIS job metadata. RRS feed

  • Question

  • 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.



    Friday, February 20, 2015 5:58 AM


  • Agent jobs you mean?

    You will not be able to find who created it unless the owner remains the person who did that, but is very unreliable.

    Question is why the un-neccessary items get crated in the 1st place. If they are temporary then there should be an un-do script.

    By the way what you did is not the best practice, you better off running each environment separately. It is very easy to use VM machines.




    Friday, February 20, 2015 2:34 PM