DSXchange

To make things clearer and readable i would translate Ray's code as such:

Do you have to kill those jobs or they abort themselves? Reset the job and see if any additional messages pop up.

How are you clearing &PH&. You need to go to TCL and issue CLEAR.FILE &PH& command from within your project. Make sure no jobs are running at that time.

Thanks guys. Could not have been possible without your support.

Also, try to change both formats using ICONV and then do the comparison, IMHO. I am not a big fan of date string comparisons.

the &PH& will be present in your projects directory. It has all the run time info. Well not all but some. Go ahead and clear that out.
What error messages are you getting in those two particular jobs?

Makes sense. Good point Whale. Totally slipped from underneath me

sainath wrote: LAST_ UPDATED > MAX(LAST_UPDATED)

If you use that statement, even in sql, it will always return 0 records as your retrieving records with timestamp greater than the max timestamp.

True. But most clients have their smtp port blocked. Can send emails but cannot recieve them on unix.

Nevermind my previous post. I did not pay attention that you were using a third party tool. Did you try running the osql utility from command line? Does it work? If it does then post the part of the code that executes the stored procedure for debugging help.

True, i understand your need. But did you read Ken's reply. Click the 'here' word in my previous post. He mentions a few limitations.

Not sure if its safe. Why ?
Read kcbland's reply here
You can even do this using an odbc stage in a job. It supports IN and IN/OUT parameters?
Any particular reservation why you want to do it via job control? You can even use STP stage if you have 7.5.2

As Craig advised, you can write your own loop. All you need to do is put your DSRunJob command within a loop that counts backwards untill it hits Jan. That is simple looping data structure.

Add an two extra columns to your output. One with derivation @OUTROWNUM and specify any dummy key on the second. Let that go down to the aggregator, group on the dummy key and choose max or last for the column which had derivation of @OUTROWNUM. Also, if you want all rows that start with '#', dont y...

Granted you are using it in JobControl. How are you talking to your database? You need an open a connection with your database to run any query on it. Right ???