Option 3 Bit complicated process but works well: 

Considering you will do Update, Insert and Delete operation on the same table at the same time by using multiple job.

1. Create a Dummy table with the target table schema with additional column called Operation_flag and Insert the rows which are needs to Updated or appended or deleted in the dummy table while inserting the rows please update the Operation_flag column with Insert, Update or Delete.
2. Filter the data based on Operation_flag in the Dummy table and do Update, Insert and Delete one by one in the target table once everything is done clear dummy table.

    For example :