Set up automated code analysis and report generation
To automate analysis of a ClearSQL project, create a job or assign a project to that job and schedule it using integrated schedules, Windows or third-party schedulers.

You can create a job based either on an existing or embedded ClearSQL project.
Based on an existing ClearSQL Project
Enable to create a new job based on an existing ClearSQL project. The job can synchronize and analyze the project, create an HTML report, and export analysis data to various formats. All data produced from this project on job execution will also be available in the ClearSQL GUI.
Based on an embedded ClearSQL Project
Enable to create a new job based on a ClearSQL project that belongs to this job. A new project is created and saved inside the job. The job can synchronize and analyze the project, create an HTML report, and export analysis data to various formats. The embedded project will not be available in the ClearSQL GUI.

Use this option if you would like to have an HTML report or exported analysis data as output of job execution.
Based on an embedded ClearSQL Project
Enable to create a new job based on a ClearSQL project that belongs to this job. A new project is created and saved inside the job. The job can synchronize and analyze the project, create an HTML report, and export analysis data to various formats. The embedded project will not be available in the ClearSQL GUI.

Use this option if you would like to have an HTML report or exported analysis data as output of job execution.
To create a job for an existing ClearSQL Project
1
Click Analyze > Job and Schedule Manager.
2
Click the New Job button.
3
Enter a job name in the editor. The job name will be listed in the job list.
4
Select Based on an existing ClearSQL Project.
5
Select a ClearSQL project in the recent project drop-down list. You can also click Open to select it from the disk.
6
Click Create Job. The newly created job will be added to the job list in the left pane.
7
On the Job tab, select scripts for analysis. To analyze the whole project, select the project root node.
8
Click Save Current to save the job.
To create a job on an embedded ClearSQL Project
1
Follow three first steps described earlier in this topic.
2
Select Based on an embedded ClearSQL Project.
3
Click Create, enter a new project name, or select it from the recent drop-down list, and then click OK.
4
In the New Project Assistant, select items (files, folders, DB objects) in the left pane, click Add or Add & Link to import them to the new project, and then click Create. A new ClearSQL project is created.
5
In the New Job window, click Create Job. The newly created job will be added to the job list in the left pane.
6
In the New Project Assistant, select items (files, folders, DB objects) in the left pane, click Add or Add & Link to import them to the new project, and then click Create. A new ClearSQL project is created.
7
Follow the rest of the steps described earlier in this topic.
Two or more ClearSQL instances on one PC cannot work with the same project. If a project is used in one ClearSQL instance, then this project cannot be analyzed by a job in another instance.
This document was last updated on February 22, 2020
Helpful?