Skip to main content Skip to complementary content

Using DDJRN.exe tool

About this task

You can start it with all its parameters and run it without a display, or start it without parameters in which case a window is displayed to guide you when entering the parameters.

When started without parameters, i.e. on SQL-PROD, the following window is displayed:

Enter parameters as follows:


  1. Source name:
    By default, it displays the name of the machine on which the program is running. If you start it up from a workstation, you must enter the name or IP address of the server on which you want to execute it.
  2. Source type:
    For the purposes of this sample procedure, enter SQL Server.
  3. Instance name:
    Enter the instance name of the server with which you want to work with, or the wildcard character * for all instances, or specify that MS SQL Server is running in single instance mode.
  4. Database name:
    In this field, enter either the name of the database on which you will clean the receivers, or enter the wildcard character * so that the DDJRN tool analyzes all the journalized databases.
  5. Environment code:
    You can use this field to enter the parameter definition environments that are analyzed to determine the journal receivers that Talend Change Data Capture no longer needs.
    You can use the wildcard character * to obtain the following results, for example:
    • E1: only environment E1 is considered in the analysis.
    • E*: all the environments whose name begins with E are considered.
    • *: all the environments are considered.
    Information noteNote: The next parameter (Environment type) impacts the environments that are considered in the analysis.
  6. Environment type:
    This parameter is used to specify that the analysis must select only the environments of the specified type. The default value of this parameter is Production to avoid test environments disrupting the cleanup operation.
  7. Retention (in days):
    This is the period of retention of journal receivers, before they are actually deleted.
    Default value is 0, but possible values are:
    • integers,
    • decimal numbers.
      Information noteNote: Only use the dot as a decimal separator. As an example, 0.5 sets the retention period to 12 hours.
    The retention period is set in accordance with the launching time of DDJRN.exe tool.
    Example: If DDJRN.exe is launched at 1 PM on the 1st of July, and the retention period is set to 1 (day), then all receivers stored before 1 PM on the 30th of June are deleted:
  8. Automation
    You can automate the receiver cleanup operation by scheduling the startup of DDJRN.EXE with all its parameters with the Windows task scheduler. To do so, copy-paste the contents of the field at the bottom of the window containing the command with its parameters based on the values that you have assigned.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!