Capturing Update/Insert Statistics Automatically
Posted: Mon Jun 06, 2011 10:09 pm
We have a requirement where we need to send the number of rows updated/inserted on specific tables to users on a daily basis. There is a set of 8-10 jobs that run everyday. All of these are quite straightforward jobs having source ODBC stage, transformer and target ODBC. The target is set to be Upsert in Update/Insert mode. As of now, after the job runs, someone checks the director log and calculates the number of updates/inserts.
Is there a way to automate this?
Is there a way to automate this?