all groups > sql server dts > march 2004 >
You're in the

sql server dts

group:

Sceduling A DTS job


Sceduling A DTS job Peter Newman
3/11/2004 1:31:12 AM
sql server dts:
I'm at a loss.. i had a job running as a scheduled task for quite a while. It was set to run ever 5 minutes every weekday between 8 - 7 , I disabled the Job as i need to make anedments to the DTS. I can not get the job to execute any more, I haqve ebven deleted the job and chreated a new scheduled job for it but that doesnt run and i can not find out why.

I can not see any errors, although i have scheduled the job as above i it is showing a next runstaus as ( date and time not avalible)

Re: Sceduling A DTS job Peter Newman
3/11/2004 4:21:06 AM
Re: Sceduling A DTS job Darren Green
3/11/2004 9:40:23 AM
Look at the job history to see when it has run.
Make sure you have the job step output file set, use this to see what
happens at the step level.
Make sure you have package logging turned on, and have a look at that to see
if the package runs at all.

What do you get from that lot?

--
Darren Green
http://www.sqldts.com

[quoted text, click to view]
while. It was set to run ever 5 minutes every weekday between 8 - 7 , I
disabled the Job as i need to make anedments to the DTS. I can not get the
job to execute any more, I haqve ebven deleted the job and chreated a new
scheduled job for it but that doesnt run and i can not find out why.
[quoted text, click to view]

AddThis Social Bookmark Button