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 |
|
jj6849
Starting Member
8 Posts |
 Posted - 2003-01-31 : 17:13:46
|
| I'm needing some advice on why a Local Package in Data Transformation Services won't run when scheduled. I'm running SQL Server 7.0. I can execute the package successfully by right clicking on it and clicking "execute package". Here's the problem, when I schedule the package (once a day at 3:00 pm), everything seems ok, but it doesn't run! I have set up an error handling log file, in the properties menu, but nothing is even recorded in the log file. I've searched through SQL Server help and still no answer. If you have any suggestions on what I might be forgetting, or doing wrong, please reply!Thanks in Advance |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-31 : 17:32:01
|
| Is the agent running.Is the job enabledIs the schedule enabled...==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jj6849
Starting Member
8 Posts |
Posted - 2003-01-31 : 17:39:42
|
| Agent is running.How do I tell if the job is enabled and the schedule enabled?Thanks. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-01-31 : 17:53:56
|
| Just go to EM, right click on the job, go to properties, the first screen should have a check box in it for enabled, then go to the schedule tab and take a look at your schedule and see if the enable box is checked. Both of them must be checked in order for it to work. The schedule gets unchecked if you ever setup the schedule to occur only once. So you have to go back in and enable if you schedule it to occur again. This does not happen on recurring schedules. |
|
|
|
|
|
|
DTS Scheduling