• I think that you are pushing the limits of what you can easily do with SQL Server Agent. Either use another scheduling engine that knows about these sort of dependencies or create a SSIS package that is responsible for running your current set of SSIS packages with the dependencies you need. Using SSIS to do this is definitely easier than SQL Agent since it already has precedence constraints etc that are an exact match for your requirements.