As I haven't received a reply I presume we are the only install of Datapump which has this requirement.
I have created the below SQL which when run using SQL Server Management Studio Express will insert a new stored procedure "SP_DUPLICATEPROCESS" into the DWCHServer database.
set QUOTED_IDENTIFIER OFF
PRINT 'Using DWCH Server Database'
PRINT 'Checking for the existence of this procedure'
IF (SELECT OBJECT_ID('SP_DUPLICATEPROCESS','P')) IS NOT NULL --means, the procedure already exists
PRINT 'Procedure already exists. So, dropping it'
DROP PROC SP_DUPLICATEPROCESS
CREATE PROCEDURE dbo.SP_DUPLICATEPROCESS
DECLARE @counter INT
-- Loop through @copies number of times appending @counter to the Process Name
SET @counter = 0
WHILE @counter < @PROCESSCOPIES
SELECT PumpProcesses_1.ProcessName' Duplicate' CAST(@counter AS varchar(3)) AS ProcessName, Description, ProcessDocument, Engine, Priority, AllowParallelJobs
WHERE ProcessID = @PROCESSIDENTIFIER
SET @counter = @counter + 1
/font[/quote]You can execute this stored procedure as follows:
Right Click on the PumpProcesses table in the Tables Section and select Open Table
Make a note of the ProcessID of the Process you wish to duplicate
Open a New Query Window and enter the following command:
This will create the required number of copies of the selected process adding Duplicate1, Duplicate2 etc to the Process Name. These can then be edited as normal in Datapump Administrator.