Reporting Tool - Elapsed Time

[Dksh Cssc]

Hi all,

I would like to retrieve the elapsed time that is associated to a
particular schedule. However when I issue the command "Select * from
actlog". The schedname is blank. So how could I have the schedule name
display when i re-issue the same command? How could I manipulate the
database part?

DATE_TIME: 2006-01-10 00:00:06.000000
     MSGNO: 403
  SEVERITY: I
   MESSAGE: ANR0403I Session 26167 ended for node KULDB01C_RT (RealTime).
(SESSION: 26167)
ORIGINATOR: SERVER
  NODENAME:
 OWNERNAME:
 SCHEDNAME:
DOMAINNAME:
    SESSID:
SERVERNAME:
   SESSION: 26167
   PROCESS:

Thanks