A schedule can be associated with multiple nodes. Hence, one can rather attempt SELECT * FROM SUMMARY which may be filtered on SCHEDULE_NAME or ENTITY(node) and the elapsed time may be calculated using the start_time and end_time.
Or Try processing the ANR2507I message from actlog: ANR2507I Schedule (schedule name) for domain (domain name) started at start (timestamp) for node (node name) completed successfully at (timestamp). -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Dksh Cssc Sent: Thursday, February 09, 2006 6:21 AM To: [email protected] Subject: [ADSM-L] Reporting Tool - Elapsed Time 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 -------------------------------------------------------- If you are not an intended recipient of this e-mail, please notify the sender, delete it and do not read, act upon, print, disclose, copy, retain or redistribute it. Click here for important additional terms relating to this e-mail. http://www.ml.com/email_terms/ --------------------------------------------------------
