visual analytics - scheduling · schedulers are used to run specified sas related job flows at a...
TRANSCRIPT
![Page 1: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/1.jpg)
Visual Analytics - Scheduling
Mark Bodt November 2015
![Page 2: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/2.jpg)
Agenda
1. What can you schedule in VA
2. Schedulers and their differences
![Page 3: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/3.jpg)
What can you schedule in VA?
Visual Data Query
![Page 4: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/4.jpg)
What can you schedule in VA?
Report Distribution
![Page 5: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/5.jpg)
What can you schedule in VA?
Report Distribution
![Page 6: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/6.jpg)
Schedulers and their differences
![Page 7: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/7.jpg)
Schedulers and their differences
Schedulers are used to run specified SAS related
job flows at a specified time. Examples:
◦ Data Integration Studio (ETL) jobs for refreshing data
warehouse tables
◦ Metadata server and SAS Deployment backups
◦ Web Report Studio Reports
Refreshing static reports
Distributing reports
◦ Visual Analytics Data Queries to refresh a LASR table
◦ Visual Analytics Report distribution
![Page 8: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/8.jpg)
Schedulers and their differences
Deployed Job:
a .sas program
that is located in a specified deployment
directory
and is registered in metadata.
Terminology
![Page 9: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/9.jpg)
Schedulers and their differences
Flow: one or more jobs arranged in sequence and / or in parallel
Terminology
![Page 10: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/10.jpg)
Schedulers and their differences
There are up to four schedulers available
by default to the SAS Infrastructure and
VA:
◦ Operating System Services
◦ SAS In-Process Services
◦ SAS Distributed In-Process Services
◦ Platform Computing LSF
![Page 11: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/11.jpg)
Schedulers and their differences
Operating System Services:
◦ Windows: Windows Task Scheduler
◦ Linux: AT command
Can only do simple time based scheduling
![Page 12: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/12.jpg)
Schedulers and their differences
SAS In-Process Services
A SAS provided scheduler
◦ Used by Web Report Studio
◦ Deprecated
![Page 13: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/13.jpg)
Schedulers and their differences
SAS Distributed In-Process Services
A SAS provided scheduler
◦ Time based events
◦ File based events
![Page 14: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/14.jpg)
Schedulers and their differences
Platform Computing (LSF and Process Manager)
A SAS provided scheduler (with DI Server )
◦ Time based events
◦ File based events
◦ Complex scheduling
![Page 15: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/15.jpg)
Schedulers and their differences
Other Schedulers:
Other third party schedulers can also be configured to work with the SAS Infrastructure
Refer to the manual: Scheduling in SAS® 9.4
![Page 16: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/16.jpg)
Schedulers and their differences
Ask your administrator
Look in the Server Manager Plug in SAS
Management Console
What’s available at my site?
![Page 17: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/17.jpg)
How to Schedule in Visual Analytics
![Page 18: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/18.jpg)
Scheduling a Visual Data Query
Setting the default scheduler
In Visual Data Builder select File –
Preferences
![Page 19: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/19.jpg)
Scheduling a Visual Data Query Setting the default scheduler
![Page 20: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/20.jpg)
Scheduling a Visual Data Query
![Page 21: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/21.jpg)
Scheduling a Visual Data Query
![Page 22: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/22.jpg)
Scheduling a VA Report Distribution Pre-requisite: Users must have their email
address registered in metadata
In Report Designer: File – Distribute Reports
![Page 23: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/23.jpg)
Scheduling a VA Report Distribution
![Page 24: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/24.jpg)
Scheduling a VA Report Distribution
![Page 25: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/25.jpg)
References:
![Page 26: Visual Analytics - Scheduling · Schedulers are used to run specified SAS related job flows at a specified time. Examples: Data Integration Studio (ETL) jobs for refreshing data warehouse](https://reader034.vdocuments.us/reader034/viewer/2022050401/5f7f8b743a2ed853466313df/html5/thumbnails/26.jpg)
Questions?