Kate_Smith

Troubleshooting Common issues with Elastic Jobs in Azure SQL Database

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started. Determining the Cause of Failure Assume for the purposes of demonstration that I have created a job with a typo (missing parenthesis before the CREATE) in […]

Troubleshooting Common issues with Elastic Jobs in Azure SQL Database Continue Reading

Running, Scheduling and Monitoring Elastic Jobs in Azure SQL Database

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started. In previous posts, I have demonstrated how to create an Elastic Jobs Agent, setup credentials for Elastic Jobs, create a target group of servers/databases for the

Running, Scheduling and Monitoring Elastic Jobs in Azure SQL Database Continue Reading

Creating an Elastic Jobs Agent, Credentials, and Jobs for Azure SQL Database using T-SQL

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started. In part 4 of my blog series on Elastic Jobs for Azure SQL Database, I will show how to create the Elastic Job Agent and associated

Creating an Elastic Jobs Agent, Credentials, and Jobs for Azure SQL Database using T-SQL Continue Reading

Creating an Elastic Jobs Agent, Credentials, and Jobs for Azure SQL Database in PowerShell

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No extra steps are required to get started. Having laid the conceptual groundwork for Elastic Jobs in two previous postings (1, 2), I am now going to create an elastic job and associated credentials

Creating an Elastic Jobs Agent, Credentials, and Jobs for Azure SQL Database in PowerShell Continue Reading

Fundamental Concepts for Elastic Jobs in Azure SQL Database

Elastic Jobs are currently in public preview.  The feature is ready and we are preparing to make it officially generally available.  No whitelisting or extra steps are required to get started. In my previous post, I explained what Elastic Jobs are and why you might consider using them. In this post, I’ll be discussing two

Fundamental Concepts for Elastic Jobs in Azure SQL Database Continue Reading

Elastic Jobs in Azure SQL Database – What and Why

Elastic Jobs is a feature of Azure SQL Database that lets you run a set of T–SQL scripts against a collection of servers or databases, as a one-time job, in an ad-hoc manner, or according to a pre-defined schedule.  This feature allows regular maintenance and any action that must be repeated – either across a

Elastic Jobs in Azure SQL Database – What and Why Continue Reading