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 |
|
filf
Yak Posting Veteran
67 Posts |
 Posted - 2001-06-26 : 06:13:01
|
| I have a number of web assistant jobs running on sql server 7.0. I have developed a little logging system so I can see how each job does all night and how long each step takes etc. I have just looked at my previous code and it is so complex considering what I am attempting to do.I know all the data I need is already in sql server, such as step duration, step results etc. Currently I am updating a dB table with the start time for each job then calculating durations via javascript funcs by subtracting the start time of the next step from the prior steps start time. If any step fails a failure step is called and I mark the job as failed in my dB table. Instead I just wish to referenece the step id of the last step to have run when the failure step is called and also reference durations etc from the sql server sys tables.I know all this data is already in sql server but as yet have not found it, and I am sure I am reinventing the wheel with the way I do it, can anyone point me in the right direction to access the properties of these particular system objects.Thanks in advance |
|
|
|
|
|
Can I reference step ID's from Web Assistant Jobs