The client's database has about 500,000 closed jobs, accumulated there since 1996. Custom reports and views run on JC files over the network is now significantly degraded. Will it help if they move part of the closed jobs into archive? What would be the correct procedure of moving closed jobs into archive in a massive batch?

Hi Alex,

Use the Delete Closed Jobs function. You will be given an option to copy to Archive. From the Help file about this:

You can delete closed Jobs from the database using this function. This will permanently remove the Job information from your JobCost data unless you have Retain archived jobs selected on the Company Profile's Options tab. If you choose to archive jobs, you will be able to view the Jobs that you have deleted from the list of Current Jobs. The Inquiries | Archived Jobs function will list these jobs and all of their details.

Any Jobs with the Keep as Template turned on will not be deleted by this function.

Thanks! It is just what I was looking for.

With 1/2 million jobs to deal with, make sure that you do this process on a local copy of the data rather than try and move all those jobs over the network. That's take forever.