DSXchange

Hi

Is there a way to know the last modified date of a Server Job.

Thanks and Regards
Manoj

If the job is cipmiled, you can see it in the director

Pey

Hi

No, The Job is not compiled.
I want to know the last saved time of the job.

Thanks
Manoj.

You can also use the contents in the DS_AUDIT Hash file to get this information. If you are not comfortable using the Administrator or command line, you could create a job and declare the DS_AUDIT hashed file along with importing the metadata for it's contents.

If you export your job design, you can view the resulting dsx file, and see lines similar to the following:

BEGIN DSJOB
Identifier "D_DATE"
DateModified "2005-08-24"
TimeModified "11.59.29"

Hi,
you can see the modified time of the job in Manager when you save the job even though you dont compile it.

You can also find the information for manager.

Hi

Thanks a Lot.
I am able to find out the time of last change by your support, Thanks again.

Is there any way to know the user id which modifed the job.

Best Regards
Manoj.

That's in the DS_AUDIT table.

A search of the forum will yield the column names for this table and examples of how to query it. Clearly there may be more than one modification, so date/time modified and by whom are stored as multi-valued columns.

deleted the question and posted it here

Please don't post the same question in multiple threads, let's just stick with this one, shall we?

Sure craig,

Actually that post was created by me so I pasted my question on that one and was about to delete it from here. :D ... discussing on this post is fine with me...

Well, crap, wish I had noticed that. You're right, that other one would have been more appropriate, I just picked the first one I stumbled across. D'oh.