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
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