You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

To schedule Profiling on a Source System,

  1. Right-click on a Source System and choose Schedule, then Data profiling.

REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling.png

  1. Select the Full radio button, the warning acceptance checkbox and click Schedule.

REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_1.png
Else select the Custom checkbox, , the warning acceptance checkbox and click Next.
REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_2.png
Select the relevant profiling options and click Schedule.
REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_3.png

  1. WhereScape 3D generates the Scheduling command to be run.

REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_4.png

    • Selecting the RED host script checkbox defines the Command as a RED host script and the drop-down list enables you to choose between a RED Windows Host Script or a RED Linux Host Script.

REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Discovery_3.png
Using Copy and Paste, you can create a host script in RED, which can then be run via the RED Scheduler. Refer to the WhereScape RED User Guide for more details.

    • Use Cron expression when you are running the command on a Unix box.Click the Calculate button and select the relevant options to select the cron interval, then click OK.

REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Discovery_6.png
The cron expression is displayed in the dialog.
REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_6.png
Click OK to close.

    • Use Schtasks expression when you are running the command in Windows.Click the Calculate button and select the relevant options to select the schtasks interval, then click OK.

REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Discovery_6.png
The schtasks expression is displayed in the dialog.
REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_7.png
Click OK to close.

Note

You will need to close 3D when you run from the command line.

For example:
The scheduling command can be copied into Notepad and saved as command.bat.
REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Data Profiling_8.png
The Schtasks expression can then be used to run command.bat from the command line.
REPLACE WITH THIS IMAGE: Images/Scheduling/Scheduling Discovery_9.png

Note

To generate the data profiling command manually, refer to Profiling using the Command Line for details.
  • No labels