SQL Agent 101: How to Use the SQL Admin Pack in Azure Data Studio!

Published: 14 August 2023
on channel: Tales From The Field
682
17

SQL Agent is a powerful feature that allows you to automate and schedule various tasks on your SQL Server instances, such as backups, maintenance, data loading, and more. But how can you use SQL Agent in Azure Data Studio, the cross-platform tool for working with SQL Server, Azure SQL Database, and Azure SQL Managed Instance? In this video, Daniel Taylor, aka DBABulldog, will show you how to use the SQL Admin Pack extension in Azure Data Studio to create, manage, and troubleshoot SQL Agent jobs.

Chapters
00:00 Intros
01:12 Azure Data Studio & Welcome Page
01:44 SQL Admin pack on the home page
01:57 Install the Admin Pack for SQL Server Extension
02:12 Examining the SQL Agent Extension
02:36 We could create a job but lets Edit one instead
04:26 How to examine alerts not showing in Job
04:55 It works with Managed Instance as well
05:18 Closing it out

Azure Data Studio Download and Install
https://learn.microsoft.com/en-us/sql...

Github for Admin Pack for SQL Server
https://github.com/microsoft/azuredat...

Download and install Azure Data Studio
https://learn.microsoft.com/en-us/sql...

#AzureDataStudio #AzureDataCommunity #SQLServer #SQL #SQLAgent


Watch video SQL Agent 101: How to Use the SQL Admin Pack in Azure Data Studio! online without registration, duration hours minute second in high quality. This video was added by user Tales From The Field 14 August 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 682 once and liked it 17 people.