I have an update statement I need to run on a table, however due to the size of this table the update takes an incredibly long time to run.
I want to create a SQL server job to run this update script for 3 hours every morning before business hours.
What I'm unsure about is, at the end of the 3 hours, it will obviously not be done updating every row, will the job just keep running until the update is complete or will it simply just stop updating any more rows until the next scheduled time? or will it fail all together?
Have not tried as this is in a live environment.