Getting the very first event of the job log

dspxlearn · Post by **dspxlearn** » Tue Apr 15, 2008 4:26 pm

Hi,

I am trying to get the first event id from the log whenever the job starts.
Using this event id i want to capture all the parameter values used in the job.
Using this is could get only the last event id.
DSGetLogEntry(JobHandle, DSGetNewestLogId(JobHandle, DSJ.LOGANY))
Can anyone suggest me how to get this?

ray.wurlod · Post by **ray.wurlod** » Tue Apr 15, 2008 4:55 pm

Why not use DSGetJobInfo() to get the parameter names and DSGetParamInfo() to get the parameter values?

If you insist on using the log, investigate the DSGetNewestLogId() function, in particular the InfoType argument to get a "Started" event.

kumar_s · Post by **kumar_s** » Tue Apr 15, 2008 5:01 pm

Or you can search for 'Job Start Time' from JobInfo.

AmeyJoshi14 · Post by **AmeyJoshi14** » Wed Apr 16, 2008 2:01 am

You can also use 'dsjob' command in the unix.
The following command will give you Start time and the End time of the particular job.

Code: Select all

$DSHOME/bin/dsjob -logsum  -type STARTED  -max 2 Project_name  TESTING_SO1(Job_name)
63      STARTED Fri Apr 11 12:42:10 2008
        Starting Job TESTING_SO1. (...)
83      STARTED Fri Apr 11 12:42:14 2008
        Finished Job TESTING_SO1.

First column is Event id from the log whenever the job starts. :D