October 11, 2006 at 12:58 am
I scheduled my dts job to run daily @ 4 am. This dts executes a stored proc to populate and export to a cvs file type. This job has been running fine until couple days ago when I opend the cvs and there are only headers but no data being populated. I looked at windows event and sql log and there's no error. The job did not fail. Can someone please explain and advise me what I should do or look for. Thanks for all the help in advance.
October 12, 2006 at 12:10 am
Hi
This might sound like a kinda stupid question but have you checked to see if there is in actual fact data being returned? Other things to check could be the service account on the SQL Agent have the rights changed? Disk space?
Mike
October 12, 2006 at 1:19 am
It still worked when I executed manually. However, when I schedule it thru a job I got nothing even though sql server log didn't have any error return.??????
October 12, 2006 at 1:44 am
Hi
When you execute the job manually it runs using your account details...When you schedule a job it runs through the SQL Server Agent start up account..Try stopping the agent and setting it to start up with your account and see if it works.
Mike
October 12, 2006 at 9:22 am
Have you turned on logging in the DTS package. Open package in SQL server and clikc on Pakcage --> Properties from menu. In the logging tab you can have it fail on first error. Put the completion status to event log etc.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply