Is there a way of querying the MSDB database on SQL server for the history of a DTS sechduled Job.
What I would like to do is to query the database and get back if the job was suggestful or unSuggestful and how long it took to run the job.
I relise you can do this within steps in a dts job, but if the server is rebooted the dts job will not do this.
Can any one tell me which tables I need to query and the columns within that table.
Thanxs for Reading