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
 General SQL Server Forums
 New to SQL Server Administration
 purge job history in msdb

Author  Topic 

ranvir_2k
Posting Yak Master

180 Posts

Posted - 2013-10-25 : 10:33:34
My MSDB database had a couple of years of history in it.

I chose to purge history older than 4 weeks. It's taking a long time.

Is there any harm in killing the SPID running this process?

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2013-10-25 : 11:29:14
could be. It may take as long to rollback the purge action as it has been running.

Be One with the Optimizer
TG
Go to Top of Page
   

- Advertisement -