DSXchange

Thanks Arnrd and Ray for the replies, I used the mentioned command and I am getting the Last Run Time in the below format if I do a Grep on the output for the Job Start Date 'Last Run Time: Month Day Year hh:mm:ss' (eg Jan 8 2008 00:00:00) I want JobstartDate in the 'YYYYMMDDhhmmss' format. Is there...

Is there any way I could get the last ran date for a particular job from the command line? I know DSJobStartDate gives the date, I dont have a clear idea about using it from the comman line. Can you guys please help me with the syntax??

Thanks Ray, I re-indexed the project when I had exclusive access and the job got deleted as a result of that. Is this how the DS.REINDEX works? Does it delete all the corrupted jobs?

Thanks Ray, I re-indexed my project in development and I can see all my jobs now.

I cannot view any of the jobs in Designer/Director/Manager, the folder containing all the jobs is empty. I can view the same jobs in Production in all the three client components but I don't see them in the Development. Is there anything I can do with which I will be able to view the jobs like befor...

Thanks all for the reply, I tried doing the LIST.READU option by logging out the 'USERNO' from the DS Server and also the DS.TOOLS option to log out the pid# related to that particular job. Both the options do not work. I tried getting the status of all the processes for the job using DS.TOOLS. It g...

Thanks all for the reply, I tried doing the LIST.READU option by logging out the 'USERNO' from the DS Server and also the DS.TOOLS option to log out the pid# related to that particular job. Both the options do not work. I tried getting the status of all the processes for the job using DS.TOOLS. It g...

Can you please throw more light on doing this using TCL DS.TOOLS? I have never done this using TCL before. Is there anyway I can do it besides logigng into the Server? Please help

Hi, I have a problem accessing a folder in the DataStage Director. The job in that folder seems to have been locked and I am not able to log out the process using the clean up resources option. I've even tried DS.TOOLS from the administrator, even that doesn't help :( . I cannot access any of the jo...

Awesome! Thanks Ronetlds, for the quick turn around!

The code "Iconv(Field(DateandTS," ",1),"D-YMD[4,2,2]")" is working perfectly fine , it was showing the negative value for some of the weeks calculated but i got rid of those using the Abs().

Hi All, Thanks a lot for your replies! I am sorry I had given the wrong format for the date. The actual date format is 'YYYY-MM-DD 00:00:00', the example of the date is '2007-12-31 00:00:00', both the dates have the same format. Does any one of the codes mentioned work for this date format?

Hi All, Thanks a lot for your replies! I am sorry I had given the wrong format for the date. The actual date format is 'YYYY-MM-DD 00:00:00', the example of the date is '2007-12-31 00:00:00', both the dates have the same format. Does any one of the codes mentioned work for this date format?

It is still inserting the zeros when I use this: ABS(ICONV('20-09-2006','D4DMY')-ICONV('23-03-1983','D4DMY')) The date format for the two dates is mm/dd/yyyy 00:00:00. Is it inserting the zeros because of the time stamp (00:00:00)? If yes, please let me know how i can eliminate the timestamp and the...

Hey WoMaWil,

Thanks for the quick reply, I checked the dates....there is no 30th February and I do not have any null values for the dates. It is still inserting the zeros, please let me know if there is any other function I can use besides Iconv

Hi All, I have two dates and I need to get a difference of those two dates and divide it by 7 to get the number of weeks. The two dates are in mm/dd/yyyy format. I was going through the posts on the same topic and found this: (Iconv(date1,"D/DMY") - Iconv(date2,"D/DMY"))/7 But wh...