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)
 'last run status' not updating

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-02-23 : 08:17:09
Phil writes "We recently moved a server to active directory and since then I am having a problem with SQL Server Agent.

'The Last Run Status (Start Date)' column is not being updated when a job completes. The 'Next Run Date' is being updated

No error is appearing in the logs and looking at the modified dates for the backup files in Windows Explorer the jobs are running successfully.

Any ideas what the problem may be.................."

clarkbaker1964
Constraint Violating Yak Guru

428 Posts

Posted - 2005-02-23 : 12:59:59
I don't know the cause of the problem but had the same occurance. Under the job steps I checked append output step to history and it started working. Can't tell you why through

You can do anything at www.zombo.com
Go to Top of Page
   

- Advertisement -