SQL Server Assessment Report
This topic contains information about the SQL Server orchestration assessment report. Orchestration scripts control scheduling, monitoring, and executing tasks. The input format for SQL Server assessment is SQL.
In This Topic:
Highlights
The highlights section gives you a high-level overview of your assessment summary based on the analysis of the selected scheduler scripts.
Summary
This section provides a high-level overview of the workload inventory. It includes the statistical information about the input SQL Server scripts, commands, jobs, and servers.
Procedure (Top 10)
This section showcases the top 10 jobs along with the number of steps involved in each job.
- Name: Lists the top 10 procedures in the source script.
- Number of Steps: Displays the number of steps involved in each procedure. Each step indicates an action or a specific task such as copy, insert, paste, etc.
Analysis
This topic provides a detailed examination of jobs existing in SQL Server scripts.
Orchestration Details
This section displays the scheduling details of jobs. It lists all the jobs along with information about the source files, and orchestration schedule details such as the start and end time of the scheduler, frequency of the scheduled jobs, etc.
- File Name: Displays the name of the source files.
- Jobs Name: Displays the name of the jobs.
- Schedule Start: Displays the job execution start date and time.
- Schedule End: Displays the job execution end date and time.
- Frequency: Displays the frequency of the scheduled jobs such as daily, weekly, monthly, etc.
- Frequency Interval: Displays the frequency interval of the scheduled jobs.
Job Details
This section provides detailed information about jobs. It lists all the jobs along with the associated source files and steps (each step indicates an action or a specific task such as copy, insert, paste, etc.).
Browse through the required jobs to get more insight into the steps.
- Step Name: Displays the name of the steps or actions.
- Step ID: Displays the ID of the steps.
- Cmd File: Displays the query information or a detailed logic to perform actions or steps.
Downloadable Reports
Downloadable reports allow you to export detailed SQL Server assessment reports of your source data which enables you to gain in-depth insights with ease. To access these assessment reports, click Reports.
Types of Reports
In the Reports section, you can see various reports such as Insights and Recommendations, and Source Inventory Analysis. Each report type offers detailed information allowing you to explore your assessment results.
Insights and Recommendations
This report provides an in-depth insight into the source input files. It contains the final output including information about SQL Server jobs.
jobs_information.csv: This report provides information about SQL Server jobs. It includes details about schedules such as start and end dates and times, frequency, and more.
Source Inventory Analysis
It is an intermediate report which helps to debug failures or calculate the final report.
SqlServerJobReport.xlsx: This report provides information about jobs including associated procedures, steps, command files, and more.
Leaplogic