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 |
|
apociecha
Starting Member
17 Posts |
 Posted - 2003-04-03 : 18:20:55
|
| I need to display (on an ASP page) the last run date of a specific stored procedure and DTS package. Is this something that is stored in the db somewhere that I can retrieve through SQL-DMO? I found out that there is a LastRunDate property that applies to the JobObject, but I'm not quite sure if I can get that information on an sproc and DTS package.Any help would be much appreciated.Agnes |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-04-03 : 18:26:11
|
| I seriously doubt that this information is stored in the database. To track the information, you will have to change your code so that when it calls the stored procedure or DTS package that it also writes to another table that stores the last run date and time.Tara |
 |
|
|
apociecha
Starting Member
17 Posts |
Posted - 2003-04-03 : 18:38:51
|
| That is exactly how I have the code working right now, I just thought that if that info was already stored in the database, I could just utilize it in my app.Thanks for reaffirming my original design and for the VERY quick response.Agnes |
|
|
|
|
|
|
last run date of sproc and dts package