Time Comparision

vijaykatneni2 · Post by **vijaykatneni2** » Wed Feb 20, 2008 9:40 pm

Hi,

How to we compare the source column timeStamp with current timeStamp.

For example i have the source column'ABC' which was updated in database 7:30PM.I am using this column as a target column,and i just want to compare this column time stamp in database with current datastage job time stamp whether it is morethan 2 hours or lessthan 2 hours.If it is morethan 2 hours and its not reached the specified conditions the datastage job should be able to send a e mail notification for the service personnel.

Thanks in advance,
Vijay Katneni.

ray.wurlod · Post by **ray.wurlod** » Wed Feb 20, 2008 9:57 pm

How about you try to design it, and offer your ideas for comment? DSXchange is not a substitute for education or support.

For example, I am reading that you are wanting a job to monitor its own execution time, which means that you will be making this check - quite expensively - for every row processed. Is that your scenario?

There's probably a good argument for a strategy that monitors the job externally, whether from a job sequence or from a routine of some kind.