March 13, 2003 at 9:24 am
Can someone tell me the best way to query for success/failure status of DTS packages. I need to obtain the information like the sp_help_job.
Kelly Ennis
Kelly Ennis
March 13, 2003 at 3:42 pm
For SQL 2000, if package logging is enabled, you can get the success/failure of the package in msdb..sysdtspackagelog and the success/failure of each step in the package in msdb..sysdtssteplog
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
March 18, 2003 at 8:04 am
I appreciate your response. Would you happen to know an easy way to accomplish the same thing in SQL Server 7.0?
Kelly Ennis
Kelly Ennis
March 18, 2003 at 3:32 pm
In SQL7, the logging is only to a text file. From memory I think this is specified on the General tab of the Package Properties window.
Hope this helps
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
March 19, 2003 at 2:33 am
I run my DTS via SQL agent and use two scripts I found on this site (modified for my own use) to show failed and running jobs. I also log my important jobs to text files as stated by phillcart for further diagnosing. This way I can monitor all the jobs on all my servers simply by using two procs.
Far away is close at hand in the images of elsewhere.
Anon.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply