visual analytics - scheduling · schedulers are used to run specified sas related job flows at a...

26
Visual Analytics - Scheduling Mark Bodt November 2015

Upload: others

Post on 30-Jul-2020

0 views

Category:

Documents


0 download

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Questions?