we have a requirement of capturing the Start Timestamp of a job and pass it to a shared container after the target table is loaded, as the target stage is not supporting output (stream links), we have split the job into two. Now , we want to pass the Start Timestamp of Job 1 to the Job 2. Any pointers on how to achieve this?
This is urgent. Please respond.
Thanks in advance
how to pass the start timestamp of one job to another job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 39
- Joined: Sun Apr 15, 2007 11:30 pm
DSJobStartTimestamp
I had a simillar scenerio in datastage v7.5.2 and i did following -
.Used a transformer macro DSJobStartTimestamp and write this value to a seq file having only column JobTS(timestamp 10).
- Then used this file in another Job and pulled the value for further use.
This approach may help you in DS v8 as well !!
Thanks
.Used a transformer macro DSJobStartTimestamp and write this value to a seq file having only column JobTS(timestamp 10).
- Then used this file in another Job and pulled the value for further use.
This approach may help you in DS v8 as well !!
Thanks
"Books are as useful to a stupid person as a mirror is useful to a Blind person."
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Why is it urgent? Why didn't you ask a week earlier? Why is it urgent on a Friday night?
We don't do "urgent". DSXchange is an all-volunteer site whose participants post as and when they can, usually only if they have something useful to contribute.
If you want urgent assistance sign up with your support provider for premium support, and learn the true cost of "urgent".
We don't do "urgent". DSXchange is an all-volunteer site whose participants post as and when they can, usually only if they have something useful to contribute.
If you want urgent assistance sign up with your support provider for premium support, and learn the true cost of "urgent".
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.
x 100ray.wurlod wrote:Why is it urgent? Why didn't you ask a week earlier? Why is it urgent on a Friday night?
We don't do "urgent". DSXchange is an all-volunteer site whose participants post as and when they can, usually only if they have something useful to contribute.
If you want urgent assistance sign up with your support provider for premium support, and learn the true cost of "urgent".
I second that reply.
Re: how to pass the start timestamp of one job to another jo
Hi,
Have you got this issue resolved ?
Once the job1 finishes, you can use a routine to capture the start timestamp. this routine's return value can be passed onto the next job.
let us know for more details.
Have you got this issue resolved ?
Once the job1 finishes, you can use a routine to capture the start timestamp. this routine's return value can be passed onto the next job.
let us know for more details.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: