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:
-
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.
-
Source type:
For the purposes of this sample procedure, enter SQL
Server.
-
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.
-
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.
-
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.
Note: The next parameter (Environment type) impacts
the environments that are considered in the analysis.
-
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.
-
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:
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:
-
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.
