Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

---

Overview/Description
An important administration task for SQL Server Reporting Services is to ensure users can only access reports and parts of the reports they require. Once users have access to the reports subscriptions can be created to ensure the reports being accessed have up-to-date data, as well as the creation of schedules to process the reports at specific intervals. This course will demonstrate how to process and view reports and how to create different subscriptions and schedules. This course is one in a series of Skillsoft courses to help learners prepare for the 70-466 Implementing Data Models and Reports with Microsoft SQL Server certification exam.

Target Audience
Business intelligence developers who create reporting and analysis solutions and individuals interested in taking the Implementing Data Models and Reports with Microsoft SQL Server certification exam

Prerequisites
None

Expected Duration (hours)
1.3

Lesson Objectives

Microsoft SQL Server 2014: Process Report and Create Subscriptions and Schedules

start the course

publish reports to a Report Server

publish reports to a SharePoint library

deploy custom assemblies with reports

save reports using Report Builder to a report server and SharePoint library

find and view reports in Report Manager and a browser

describe what requirements need to be met before a subscription can be created, the different extensions, and their parts

create a standard subscription for a report in Report Manager

create an e-mail subscription in Report Manager

create a data-driven subscription in Report Manager

modify settings for subscriptions and delete them

create a schedule for a report

create a shared schedule for a report when Reporting Services is in Native mode

create a shared schedule for a report when Reporting Services is in SharePoint mode

manage schedules, including pausing, resuming, and changing settings

monitor the status of running jobs on the Report Server

configure security, process and view reports, manage subscriptions and schedules, and manage the Report Server

Course Number:
md_idmr_a12_it_enus

Expertise Level
Expert