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 |
|
kdog
Starting Member
14 Posts |
 Posted - 2006-01-10 : 14:51:11
|
| Hi all, I have a dts package that is scheduled to run every 5 minutes, Monday - Saturday from 9AM to 9PM. But every morning when I check the job it isn't running. The actual job itself is enabled, but when I look at the details of the job i.e "schedules" tab it shows the schedule disabled. I have to enable the schedule everyday - a super pain in #%#%. Anyone have any idea what could be causing this too happen?btw - I'm using SQL 2000 Standard |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2006-01-10 : 14:54:37
|
| Only thing that I can think of is if the schedule has an end-date associated with it. By default, though, that is something well into the future. |
 |
|
|
kdog
Starting Member
14 Posts |
Posted - 2006-01-10 : 14:57:11
|
| I have the schedule set to have "no end date".... |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-10 : 18:53:08
|
| Tried deleting and recreate the schedule ?-----------------'KH' |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
kdog
Starting Member
14 Posts |
Posted - 2006-01-10 : 19:08:19
|
| you didn't have to rat on me :P |
|
|
|
kdog
Starting Member
14 Posts |
Posted - 2006-01-11 : 09:19:43
|
| The answer was install SP4...duhThanks tkizer for the solution too this issue ;)see>> http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=60084 |
|
|
|
|
|
|
SQL Schedule that disables itself