• I might be way off base here -- and I don't wish to downplay any of the work you have presented -- but how is this significantly different from the SQL Agent running some SSIS packages?

    The SQL Agent already takes care of scheduling, history, logging and notification (and can even manage basic stepped, batch-style tasks), with SSIS providing the flow control and reusable blocks that would probably comprise your diagrams.

    I can see how your structure and procedures might be of some use in some other RDBMS but, in SQL Server much of this is already taken care of.

    What notable benefits does your solution provide over the SQL Agent?