Page 1 of 1

How to capture job start time, end time, name etc

Posted: Thu Aug 10, 2017 2:08 pm
by mallikharjuna
How to save this jobname, endtime..etc in file?

Posted: Thu Aug 10, 2017 2:11 pm
by mallikharjuna
Please let me know how to save this information in text file

Posted: Thu Aug 10, 2017 2:13 pm
by PaulVL
Use the DSODB database for those stats.

Posted: Thu Aug 10, 2017 2:25 pm
by chulett
:!:

Split this out from an old and previously hijacked discussion into one of its own. And from looking at previous topics started by the OP, they are on 11.x so updated the post accordingly.

Posted: Fri Aug 11, 2017 2:52 pm
by UCDI
a hands-on way is to open the job in director, print the current run to a file (set up a generic text file printer 'device'), and if you don't want all the juicy data in there, cut out the lines you need.

This file is just full of great info -- you can see how long each stage or sub-sequence ran, and you can see the job's parameters, and lots of other cool stuff for hands-on job profiling.

Posted: Fri Aug 11, 2017 2:57 pm
by PaulVL
UCDI if the brute force way is acceptable...

$DSHOME/bin/dsjob -jobdetails <project> <job.invocation> > /path/joblog_<project>_<job>.log would be the way to script it, then grep/cut the timestamps from that.

Or ...

create a datastage job that runs against the DSODB database to extract your stats there. Much better use of the environment.

I would slap an application team that did a log scrape just for stats now that DSODB is there.