Query trans log or tempdb?
If you add the output clause at the end of each update statement with a COUNT(inserted.*) the counts of updated records will be returned as a result set.

You could create a new table in a new database to store the results from your scheduled script or have the SQL Agent output the results to a file.

Have a look at this answer for help with OUTPUT clause here