SQL elastic job not starting and no logs as well

Rocky420 21 Reputation points
2020-06-18T18:12:13.617+00:00

Hello Team,

we are using sql elastic job from past few months and we are seeing no issue but all of sudden , we see that our job are not running and even if we manually start the job , then it states moves to create but it not running and there is no record in execution table , so we do not know what went wrong and why it is not working

can some one help here

Azure SQL Database
{count} votes

1 answer

Sort by: Most helpful
  1. Mustafa Elmasry 76 Reputation points
    2020-07-01T22:44:03.6+00:00

    Hi @Rocky420
    Can you check this article it can help you for reviewing the configuration of Azure elastic job and let me know if the issue still exists or if it is solved it will be great to share with us your experiences
    Thanks
    https://mostafaelmasry.com/2020/05/26/azure-sql-elastic-database-job-agents-configuration/

    Mustafa EL-Masry
    Independent SQL Server Consultant, DB Performance Tuning Specialist, AZURE, Technical Author
    https://www.linkedin.com/in/mostafaelmasry/
    https://mostafaelmasry.com/
    http://www.sqlidol.com/
    M| +966 54 399 0968

    0 comments No comments