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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 DTS Job executes but doesn't update

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-07-06 : 07:42:48
Jeanean writes "I have a DTS job that is scheduled to run each morning. I have it set to send me an email on completion. I get the emails each morning letting me know that it ran. When I look in the status window it says it ran and completed successfully. However, it isn't updating the data.

If I go in and manually run the job the data is updated. This instance started when we upgraded the server to Windows 2003. At first I was getting errors which were resolved once I changed the owner to SA. However know it "appears" to run the job successfully but isn't.

Any suggestions?"

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-07-07 : 07:01:05
post the job history and details?

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -