Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vdpramesh
Starting Member
12 Posts |
 Posted - 2004-04-10 : 11:38:33
|
| Hi, I would like to know, is there any way where i can find the JOB History(Last Run whether it is successful or Not and Last run date) in the Sql server thru Programitaclly.(VB.Net).Some of the jobs are from DTS also.Pls help this would helpful for me to monitor the activites in production server.Thanks in AdvanceRamesh. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2004-04-10 : 11:53:07
|
| Never used it myself but I'm quite sure you can get quite alot of info from sp_help_jobhistory. Look it up in BOL...--Lumbago"Real programmers don't document, if it was hard to write it should be hard to understand" |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-10 : 12:13:20
|
| The sp_help_jobhistory will work for both. I would assume you are running the DTS packages through jobs. So, you should be able to see the history of both. It does give the job name, last run, duration, and success or failure.If you are want a more granular picture of the DTS packages, use sysdtspackages and sysdtspackagelog. This give the information specific to the DTS packages.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
vdpramesh
Starting Member
12 Posts |
Posted - 2004-04-11 : 04:36:54
|
Thanks a lot ..This works fine..Rameshquote:
Originally posted by derrickleggett
The sp_help_jobhistory will work for both. I would assume you are running the DTS packages through jobs. So, you should be able to see the history of both. It does give the job name, last run, duration, and success or failure.If you are want a more granular picture of the DTS packages, use sysdtspackages and sysdtspackagelog. This give the information specific to the DTS packages.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA.
|
|
|
|
|
|
|
|
|
Job history in Sql server.