Capturing Update/Insert Statistics Automatically

abhilashnair · Post by **abhilashnair** » 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?

chulett · Post by **chulett** » Mon Jun 06, 2011 10:23 pm

Write out the steps they do to calculate the numbers from the log. Look into using dsjob to pull the relevant information from the job logs at the command line and scripting to get what you need from the output. That or a Server job or routine to code the same thing in BASIC using the DSGet* functions from the API.

Write the results out to a file and use a Sequence job to send an email and attach the results to it... that or with a little more work inline them.