Applied SP 2a on SQL 2K5 - now all jobs schedules are duplicated!!!!!!

[sanjdhiman]

Hi

This is really really annoying, I have checked on Microsoft website and other forums about this apparent problem with maintenance tasks, or just generally anything that is scheduled via SQL SErver Agent going out of sync or jobs for no reason running twice, i.e. my backups are running twice for now reason!!!!!

Does anyone know how to fix this, I have applied SP2a (after march 17th) and now everything is duplicating for no reason!!! any ideas???


Thanks

Sanj

 

[mrdenny]

Does the job history show that the job in running twice? What about the application log and system log?

What do the schedules look like (both in the gui and in the msdb.dbo.sysjobschedules table directly).

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[sanjdhiman]

Job history shows two schedules, I deleted and re-created them and now it has fixed it but its such a bad thing when upgrading from SP1 to SP2(a)

Their were schedules in sysjobschedules which had no schedule_id inside of sysschedules

However, It is fixed now by deleting the jobs and re-creating them now that I have applied the SP2(a) patch on the client tools.

Thanks

Sanj

 

[mrdenny]

That's very strange. I've never sean that issue before and I've patched dozzens of machines with SP2a. You should report the issue to Microsoft via there Connect system at

http://connect.microsoft.com.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com