Azure SQL Database
An Azure relational database service.
6,308 questions
Azure Elastic Job runs without errors but doesn't appear to call stored procedure
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(313.6, 26%, 40%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECW%3C/text%3E%3C/svg%3E)
Chris Ward
1
Reputation point
I have an Azure Elastic Job set up to call a stored procedure on 10 different shards.
I can run the SP on the shards from SSMS and each shard takes anywhere from a few minutes to over an hour from SSMS
When I start the Elastic job it runs for a couple of hundred seconds it varies and then says that it finishes successfully.
I don't feel it's actually calling the SP or finishing because it finishes so quick compared to running the same SP from SSMS
What can I do to figure out what the issue is?
Azure SQL Database
{count} votes
-
Oury Ba-MSFT 20,901 Reputation points Microsoft Employee Moderator2023-06-02T23:02:38.7033333+00:00 Chris Ward Thank you for reaching out.
Could you check the database logs to see if the stored procedure is being called, you can use the SQL Server Management Studio (SSMS) to view the logs.
Regards,
Oury
-
Chris Ward 1 Reputation point
2023-06-04T16:13:30.8966667+00:00 Looking at dm_exec_procedure_stats I can see it is executed for less than 1 second
-
Deleted
This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
-
Oury Ba-MSFT 20,901 Reputation points Microsoft Employee Moderator
2023-06-06T22:12:45.3566667+00:00 -
Chris Ward 1 Reputation point
2023-06-07T00:13:41.2833333+00:00 Thank you I do appreciate the help, I've been trying to figure this out for a month.
-
Oury Ba-MSFT 20,901 Reputation points Microsoft Employee Moderator
2023-06-08T03:00:23.29+00:00 @Chris Ward Thank you for your patience while working on this issue.
Shardmaps are not supported as targets of Elastic Jobs at this point. You can raise this feature request at Azure SQL feedback.
Regards,
Oury
-
Chris Ward 1 Reputation point
2023-06-08T05:07:30.7766667+00:00 @Oury Ba-MSFT what would be the recommended way to schedule this then? Everything I found said to use Elastic Jobs with Azure SQL
-
Oury Ba-MSFT 20,901 Reputation points Microsoft Employee Moderator
2023-06-12T16:50:46.32+00:00 We don’t have any recommended solution for targeting shardmaps in SQL databases at this point. You may be able to use Azure automation or Azure Functions for this purpose.
Regards,
Oury
-
Oury Ba-MSFT 20,901 Reputation points Microsoft Employee Moderator
2023-06-12T16:58:42.35+00:00
Sign in to comment
Sign in to answer