Is there a way to ensure one or more SQL DBs is always backed up after another DB's backup finishes? For example, given DBs dataA, dataB, dataC, and dataD:
dataA and dataC can start anytime after 8pm
dataB must start ONLY AFTER dataA and dataC are both finished backing up
dataD must start ONLY AFTER dataB is finished backing up
So D is dependent on B, and B is dependent on A and C.
The backup times will not be consistent, so I am not comfortable simply putting them in their own subclients and then scheduling each subclient hours apart. I bet this could be accomplished via workflow but I was looking for a more "native" solution.