We have a need to push data to the Production environment after a business analyst has reviewed the data in a Test environment. Is there a recommended way that the push to the Production environment be automated instead of manually pushed? One idea being considered is having update capability on a status flag on a control table. A scheduled job will execute at a certain interval and interrogate the control table to see what if any data is associated with an updated status flag to indicate that the data is ready to be pushed to the Production environment.