The effects of intravenous sedation can vary depending on the medication used and the dosage administered. However, most patients will start to feel more alert and awake within a few hours after the procedure.