(Kenneth Fisher) Generally if I need to do any form of complicated control flow I’ll end up using SSIS, however there is also a limited about of control flow available in SQL Agent jobs. Here are a couple of examples of how it works and what you can do with it.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help