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)
 Server agent jobs

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-15 : 07:30:13
Jason writes "I have a job that runs every hour getting data from an external source. The problem is that I have to re-enable the job every morning for it to continue running because some how the enabled flag resets its self. I am using SQL server 2000, I think the service pack is 4 but the help about just said version 8.0. The OS is windows server 2003."

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-15 : 08:35:24
Does the MSDB get overwritten overnight perhaps?

====================================================
Regards,
Sean Roussy

Thank you, drive through
Go to Top of Page
   

- Advertisement -