Sequence Elapsed Times
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54
- Joined: Mon Dec 24, 2007 9:27 am
Sequence Elapsed Times
Hello Everyone,
We have created an after job sub routine, which would get the details like runtimes, record count, cpu... into a file, which will be later loaded into a Teradata table for analysis. This routine is called in all jobs in "After Job Subroutine".
The question is, how can I capture the sequence run times?
Thanks for the help in advance
Kishore
We have created an after job sub routine, which would get the details like runtimes, record count, cpu... into a file, which will be later loaded into a Teradata table for analysis. This routine is called in all jobs in "After Job Subroutine".
The question is, how can I capture the sequence run times?
Thanks for the help in advance
Kishore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54
- Joined: Mon Dec 24, 2007 9:27 am
-
- Participant
- Posts: 54
- Joined: Mon Dec 24, 2007 9:27 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
The same argument that applies to an after-job subroutine, isn't it?kishorenvkb wrote:Ray, adding the Rotuine Activity within the sequence cannot help me to capture the EndTimeStamp of the sequence as technically the sequence is not complete until after the Routine Activity is completed. Isn't it?
The times to the nearest whole second are likely to be identical anyway.
You can always run a completely separate routine/sequence to retrieve this information once the sequence under investigation has completed successfully.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 54
- Joined: Mon Dec 24, 2007 9:27 am
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your problem is easily remedied.kishorenvkb wrote:I cannot see anything that Ray wrote as I am not a member. Hopefully the members got some benefit out of this conversation.
Thanks anyways!
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.