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 |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2008-12-10 : 03:38:52
|
| i can use exec sp_help_job @job_name='' to view on screen the last run outcome and date but this sp returns 4 tables in one outcome. How can i just get the last run outcome and date into a parameter |
|
|
jtwork
Yak Posting Veteran
82 Posts |
Posted - 2008-12-15 : 15:25:39
|
| does anyone have an idea on this one???? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
jtwork
Yak Posting Veteran
82 Posts |
Posted - 2008-12-16 : 14:43:27
|
| this has done the job but does anyone know how to convert the run time to a time looking value that can be joined to the date (this bit i can do once i can find out how best to get the date in a good format). |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 23:48:55
|
| you mean you want to add runtime to date? use date functions like dateadd |
|
|
|
jtwork
Yak Posting Veteran
82 Posts |
Posted - 2008-12-17 : 05:16:23
|
| i do and i know how to do that but its the run time. run time is hhmmss however when looking at some of the run_times using sp_help_jobhistory they are coming unusual for example out as 1307, now is this 013007 or 130700 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-17 : 05:43:38
|
| http://jon.netdork.net/2007/02/23/sql-job-monitoring |
|
|
|
|
|
|
job status