Course 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.
Learning Objectives
Process and View Reports
- 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
Subscriptions and Schedules
- 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
Practice: Manage Reporting Services
- configure security, process and view reports, manage subscriptions and schedules, and manage the Report Server