Thanks Eric.

But then i want to do this periodically(say every night). For example, as and when the jobs are completed for a particular order, we need to move them to reporting database. only those jobs that are still running will remain the operational database

is there a way we can achieve tat using SSIS?