Query DS Job History

This issue has been solved. See solution.
Antonp's picture

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?

Antonp's picture

 I found the table in the

Solution

 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