Andrew Connell

Is your background processing working?

I recently ran across something that I thought I'd share as you may have done the same. We had a ASP-based website that was completely database driven that we were porting over to MCMS. New UI, new organization, you name it... this site was going to replace our old one completely. Beacuse we elected to not use a data conversion application and port all data manually (we had our reasons... for one, we wanted to proof everything as we had recently undergone an acquisition and we wanted to examine all text & links), and some other reasons, we started putting content into the DEV database. Our plan was just to copy the SQL DB files, create a new DB in our production & QA environment, and reattach the database to the new files. That way, the content could be added before the site was finished (it was a tight deadline… ideally you want to finish the site coding or at least get it to a point where data can be input while dev is still going on for more advanced things or layout, but we didn’t have that luxury). This worked great… but what didn’t it do? Because the DCA...

I recently ran across something that I thought I’d share as you may have done the same. We had a ASP-based website that was completely database driven that we were porting over to MCMS 2002. New UI, new organization, you name it… this site was going to replace our old one completely.

Beacuse we elected to not use a data conversion application and port all data manually (we had our reasons… for one, we wanted to proof everything as we had recently undergone an acquisition and we wanted to examine all text & links), and some other reasons, we started putting content into the DEV database. Our plan was just to copy the SQL DB files, create a new DB in our production & QA environment, and reattach the database to the new files. That way, the content could be added before the site was finished (it was a tight deadline… ideally you want to finish the site coding or at least get it to a point where data can be input while dev is still going on for more advanced things or layout, but we didn’t have that luxury).

This worked great… but what didn’t it do? Because the DCA creates the background processing job in the step of creating the MCMS database, that job just wasn’t created. Doh! We realized that some time later.

Learn from my mistake… go check your MCMS database and see if the SQL Agent is running the background process.

» MSDN: Using MCMS Background Cleanup

Andrew Connell
Developer & Chief Course Artisan, Voitanos LLC. | Microsoft MVP
Written by Andrew Connell

Andrew Connell is a web developer with a focus on Microsoft Azure & Microsoft 365. He’s received Microsoft’s MVP award every year since 2005 and has helped thousands of developers through the various courses he’s authored & taught. Andrew’s the founder of Voitanos and is dedicated to delivering industry-leading on-demand video training to professional developers. He lives with his wife & two kids in Florida.