Autoplay
Autocomplete
Previous
Next
TimeXtender Classic - Optimization
Getting Started
What to Expect: Course Overview
Developer Tools
Quick Start: Project Perspectives
Exercise: Create Perspective
Quick Start: System Control Fields
Quick Start: SQL Database Cleanup Tool
Quick Start: Table Performance Settings
Quick Start: Index Automation
Quiz: Developer Tools
Schemas, Views and Simple Mode
Quick Start: Schemas
Exercise: Create Schema and assign Behavior
Quick Start: Views
Exercise: Create, Edit and Synchronize View
Exercise: Enable Simple Mode
Quiz: Views and Simple Mode
Data Quality
Quick Start: Primary Key Behavior
Quick Start: Relationship Types
Exercise: Referential Integrity
Quick Start: Handling Nulls
Quick Start: Validation Rules
Exercise: Create Data Validation rule
Quick Start: Warnings and Errors
Quiz: Data Quality
Surrogate Keys and History
Quick Start: Supernatural Keys
Exercise: Add Supernatural Key
Quick Start: History
Exercise: Enable History Type I for Customer table
Quiz: Surrogate Keys and History
Incremental Load
Overview: Incremental Load
Foundation: Incremental Loading
Exercise: Incremental Load in ODX
Quick Start: Incremental Loading in Data Warehouses
Quiz: Incremental Load
Compliance
Quick Start: Data Lineage
Quick Start: Documentation
Quiz: Compliance
Execution
Quick Start: Execution Packages
Quick Start: Schedules
Exercise: Add and Schedule Execution Package for Sales
Quick Start: Execution History
Quick Start: Execution Queue
Quiz: Execution
Next Steps
Quick Start (optional): Using Azure SQL DB Serverless
TimeXtender Tuesday
Next Steps
Feedback
Exercise: Add and Schedule Execution Package for Sales
Open the
Execution
tab from the
Solution Explorer.
Right click
Execution Packages
node and choose
Add Execution Package
In the
Name
box type
Sales
Drag the Project Perspective
Execute Sales
from the
All Steps
box to the
Include Steps
box
In the
Max. Threads
box type
5
or use the up/down buttons.
In the
Managed Execution
box choose the option
Execution Time
and click
OK
button.
Click
OK
in the information box with the message
"Deployment is needed before changes will have an effect".
This applies to scheduled executions only.
Show Example
Note: Video is free of audio
Add Schedule to Execution Package
Right click
Execution Package
named
Sales
and choose
Add Schedule.
If schedules already exists the option will be
Edit Schedule
In the
Schedule
window choose
Specified Hour,
type hours and minutes and click
Add
button followed by
OK
Right click the
My Training Project
node and choose
Advanced -> Save project as deployed version.
Show Example
Note: Video is free of audio
Next
Lecture Content Locked
Your session expired. Please sign in again to continue.
Login