DSXchange

Giving back to the community :) --Job Runs on DSODB SELECT UPPER(J.PROJECTNAME) PROJECT_NAME, J.JOBTYPE JOB_TYPE, UPPER(J.JOBNAME) JOB_NAME, R.RUNID RUN_ID, R.INVOCATIONID INVOCATION_ID, R.RUNSTARTTIMESTAMP RUN_START_TIME, R.RUNENDTIMESTAMP RUN_END_TIME, TIMESTAMPDIFF(2, CHAR(TIMESTAMP(R.RUNENDTIMES...

Revisiting this post with everything that I managed to do so far.. and where I hit a wall :) Thanks all for pointing to the DSODB. That was a great place to start mining all the job run information. Plus, its so nicely documented! Thumbs up to IBM! Now, the caveat, our DSODB is not logging stage lev...

ray.wurlod wrote:The logs are accessible, and exportable, from the Operations Console. ...

Thank you for the response!

PaulVL wrote:Oh if only you had a tool that could query a database, create a comma separated file, then sftp the file to that remote host or even connect directly to that target database and load it...

If you got your hands on that tool... man the possibilities...

lol

Thanks Craig! That's a great pointer! Agreed on Operations Console being a good place to start with. But one caveat is that I need to be able to ship all of the data that I see in operations console to a separate reporting database built for a capturing the jobs and stages run stats data with report...

Hi Gurus, I am pretty new to the DS admin side of things. I am working to compile and gather all the stats that are available for job running on datastage, the intention being to be able to create a report to identify our long running jobs and their stages. Can someone here point me in the right dir...