obtaining Job Start/End time information externally

ukyrvd · Post by **ukyrvd** » Fri Jun 24, 2005 4:05 pm

Hi
I am fairly new to datastage and still in learning stage. I know, We can get this information by calling dsjobreport routine as after job routine.
But
I am wondering if there is any way to get this info from command line or if can write a script for doing so taking job name as an input or even a new job data stage that can take job name as input parameter and produce an text files with those detail.

Thanks in advance
Prasad

ukyrvd · Post by **ukyrvd** » Fri Jun 24, 2005 4:26 pm

Never mind.
I got it. I wrote a routine that can be called from transformer.

thanks

ukyrvd · Post by **ukyrvd** » Tue Jul 12, 2005 8:35 pm

Hi,
I was wondering if there is a way to get a list of jobs called by given sequence?

thanks

roy · Post by **roy** » Wed Jul 13, 2005 4:38 am

Hi,
Open the online help of the designer and type macro.
In the page there are 2 blue links click on the top one.
This will show you several macros that hold info similar to what you can get with the DSGetJobInfo routine and exists foreach job while it it running.

In your case you can simply use DSJobStartTimestamp.

As for end time you need to wait for the job to end so a close call might be using and after job routine to get the current time.

It all depends on what your implementing.

as for getting the list of jobs from sequence it was covered before, search for it.

IHTH,

ukyrvd · Post by **ukyrvd** » Wed Jul 13, 2005 8:46 am

Hi Ray .. thanks for the reply.

I have modified DSJobReport to get start/end time of job during its last run. So I am fine with that.

as for getting the list of jobs from sequence it was covered before, search for it.

I did that .. went through atleast 10 pages of results

.. may be I am doing with wrong key words.

From some of the posts, I feel it can be worked out if I start at DS_JOBOBJECTS. I will see if I can get that!!

thanks
Again.

roy · Post by **roy** » Wed Jul 13, 2005 9:08 am

Ok your like the 10th person to mistake me for Ray!
As flattered as I may be and as willing to give Ray any credit I'm not him

I've got several private messages the past month or so again from people mistaking me for Ray, so let me just clear it up before anyone else makes this mistake

I'm Roy not Ray

Would love to meet him and learn something (not nothing as a tennis player might interpert the love part, by the way loved that sig over your current one Ray

)

ukyrvd · Post by **ukyrvd** » Wed Jul 13, 2005 10:03 am

OOOps .. sorry about that Roy.

BTW, I have worked my way through it. Just went through some of the code posted by Kim on his website and modified to suite my needs. I hope thats fine

Thanks.