p.p.s.  BTW, what's the data type of that JOB_INFO  column?

p.s.  We really need to fix that 50% FILL FACTOR thing.  It's wasting a ton of memory.  We can look at that once we've solved your original problem.

Ok... here we go...

First, I wanted to make sure that I had the same volume of data you have.  I'd forgotten to ask you to post the DDL...

Here's an example of how short the code can be thanks to sys.master_files.
 SELECT  DatabaseName           = DB_NAME(database_id)
        ,FileType               = type_desc
        ,dbFileLogicalName      = name
        ,dbFilePhysicalFilePath =...

"It Depends".  What is the purpose of copying the data to the target table and what will the target table be used for?

Also, does the target table start...