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

This course is included in our On-demand training solution.

Overview

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

60 min.

Course Objectives

Course Introduction

Publishing Reports to a Report Server

  • publish reports to a Report Server
  • Publishing Reports to a SharePoint Library

  • publish reports to a SharePoint library
  • Deploying Custom Assemblies with Reports

  • deploy custom assemblies with reports
  • Saving Reports Using Report Builder

  • save reports using Report Builder to a report server and SharePoint library
  • Viewing Reports in Report Manager and a Browser

  • find and view reports in Report Manager and a browser
  • Understanding Subscriptions for Reports

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

  • create a standard subscription for a report in Report Manager
  • Creating an E-mail Subscription

  • create an e-mail subscription in Report Manager
  • Creating a Data-driven Subscription

  • create a data-driven subscription in Report Manager
  • Modifying and Deleting Subscriptions

  • modify settings for subscriptions and delete them
  • Creating a Schedule

  • create a schedule for a report
  • Creating a Shared Schedule for Native Mode

  • create a shared schedule for a report when Reporting Services is in Native mode
  • Creating a Shared Schedule for SharePoint Mode

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

  • manage schedules, including pausing, resuming, and changing settings
  • Managing Running Jobs

  • monitor the status of running jobs on the Report Server
  • Exercise: Managing Security, Processing, and the SSRS

    SUBSCRIPTION COST



     

    NEED HELP OR NOT SURE?