September 26, 2005 at 7:47 am
Hi Guys, Can anyone tell me why my DTS packages in SQL 2000 always show 12:00AM when I try to schedule them. Is this normal operation or there are some settings I have to set? It is very annoying not being able to see the actual time the packages have been scheduled to run at.
Thanks
Emilio
September 26, 2005 at 8:09 am
Where is it showing 12:00AM and at what time are they scheduled?
September 26, 2005 at 8:33 am
It has been scheduled at 7:00 PM and it does run fine at 7:00 PM but when I go to change the schedule it shows 12:00 AM. This is in Enterprise manager when right clicking on the package and choosing shedule package.
Emilio
September 26, 2005 at 8:51 am
That's the problem. That route creates a new job. You need to do in the sql server agent section and you'll see the times where it has been run/scheduled there.
September 26, 2005 at 9:01 am
That was it, thank you very much. You are owesome
Emilio
September 26, 2005 at 9:02 am
HTH.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply