April 21, 2003 at 8:20 am
I have a DTS package which should run everyday at 10 pm.And i created the package and sceduled it to run at that time using the dts wizard.Actually i created the package on 18th and scheduled to run on that day 10 PM.but its not running on everyday as scheduled.when i look at the sceduling time to execute that package it shows today's date and time as 10 PM.The package did not executed on 18th,19th and 20th.What sholud be the reason for that and how can i make that packeage to run everyday as per the schedule.
April 21, 2003 at 8:30 am
Check the created job under SQL Server Agent and verify the schedule.
In EM:
Management | SQL Server Agent | Jobs
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 21, 2003 at 8:41 am
its scheduled properly and the last run status is failed.what should be the reason how can I make it successful
April 21, 2003 at 8:46 am
If you right-click on the job, you'll get a pop-up menu. Select View Job History. This should give you a list of all the times the job has run, how long it took, and whether or not it was successful.
You may need to click on the checkbox Show step details to look at the job step and see what the error was.
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
April 25, 2003 at 4:57 am
This isn't helping you with your problem, but maybe could improve your error handling.
That "view job history" is kinda rough and hard to read imo. The best thing to do is to create an error file in your DTS.
Simply right click somewhere in your DTS, go to "Package properties" - "Logging" - and add an error file.
After this, you can check this file for more detailed information.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply