Find the Last Modified Date of a Job

manojmathai · Post by **manojmathai** » Tue Sep 13, 2005 5:27 am

Hi

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

Thanks and Regards
Manoj

Peytot · Post by **Peytot** » Tue Sep 13, 2005 5:34 am

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

Pey

manojmathai · Post by **manojmathai** » Tue Sep 13, 2005 5:56 am

Hi

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

Thanks
Manoj.

ArndW · Post by **ArndW** » Tue Sep 13, 2005 6:25 am

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.

chucksmith · Post by **chucksmith** » Tue Sep 13, 2005 7:06 am

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"

iwin · Post by **iwin** » Tue Sep 13, 2005 7:27 am

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

sankarsadasivan · Post by **sankarsadasivan** » Tue Sep 13, 2005 7:45 am

You can also find the information for manager.

manojmathai · Post by **manojmathai** » Tue Sep 13, 2005 10:00 am

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.

ray.wurlod · Post by **ray.wurlod** » Tue Sep 13, 2005 4:52 pm

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.

synsog · Post by **synsog** » Tue Nov 02, 2010 7:01 am

deleted the question and posted it here

chulett · Post by **chulett** » Tue Nov 02, 2010 7:15 am

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

synsog · Post by **synsog** » Tue Nov 02, 2010 7:39 am

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...

chulett · Post by **chulett** » Tue Nov 02, 2010 8:59 am

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.