Search found 6 matches
- Thu Oct 25, 2018 1:57 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6831
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...
- Wed Sep 19, 2018 7:07 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6831
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...
- Wed Sep 05, 2018 12:51 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6831
- Wed Sep 05, 2018 12:49 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6831
- Tue Sep 04, 2018 8:09 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6831
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...
- Tue Sep 04, 2018 4:56 am
- Forum: General
- Topic: Log files for all job runs
- Replies: 12
- Views: 6831
Log files for all job runs
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...