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 it:

 

I run the job several times, but it fails. We can see this in the portal, or through Azure Cloud Shell:

 

We can confirm the failure by issuing the following query in Sql Server Management Studio when connected to