Automating tasks with elastic jobs, SQL Agent and Automation

DP-300 · Configure and manage automation of tasks · Updated

Choose between elastic jobs, SQL Server Agent, Azure Automation and Logic Apps to schedule maintenance and T-SQL across Azure SQL.

This lesson is part of full DP-300 access

The first 2 DP-300 lessons are free. Full access opens every lesson with its practice questions, and the exam-style DP-300 question bank.

In this lesson
  • Choosing the scheduler
  • Elastic jobs
  • SQL Server Agent
  • Azure Automation
  • Alerts
  • Exam traps
  • Practice questions

Get full access Try the free practice exam Log in

DP-300 course outline

All 6 lessons · Course overview
  1. Choosing the right Azure SQL optionPlan and implement data platform resources Free
  2. Migrating SQL Server to Azure SQLPlan and implement data platform resources Free
  3. Securing Azure SQL authentication and dataImplement a secure environment Full access
  4. Monitoring and tuning Azure SQL performanceMonitor, configure and optimize database resources Full access
  5. Automating tasks with elastic jobs, SQL Agent and AutomationConfigure and manage automation of tasks Full access
  6. High availability, disaster recovery and backupsPlan and configure a high availability and disaster recovery environment Full access