Video Screencast Help
Search Video Help Close Back
to help
New in the Rewards Catalog: Vouchers for "Symantec Technical Specialist" and "Symantec Certified Specialist" exams.

Query DS Job History

Updated: 21 May 2010 | 1 comment
Antonp's picture
0 0 Votes
Login to vote
This issue has been solved. See solution.

I'm trying to query the eXpress database for all my DS jobs and the last time that they were executed. Managed to get the job locatons on the server, but now need the date and time that they were last ran. Could someone assist with whch tables i can have a look in?

Comments

Antonp's picture
17
May
2009
0 Votes 0
Login to vote

 I found the table in the

 I found the table in the database that would generally keep the information of all jobs executed, dates, times and status of these jobs. But a more in detail query needs to be created to link the jobs to the correct hostname. But for me this table was the one i was looking for.

select * from status_log

Technical Consultant
Http://www.alttech.co.za