Random stored procedure in the batch file did not get executed occasionally

Question

Background of the issue:

My batch file will execute several stored procedure and it is working fine all the while. However, some random stored procedure will not get execute occasionally. When I re-execute the batch file, it just works fine.

For example, below batch file section will execute stored procedure "LOAD_AAA", "LOAD_BBB", "LOAD_CCC" in sequence. However, sometime the "LOAD_BBB" stored procedure did not get executed or sometime the "LOAD_CCC" did not get executed, it is random.

What could be the potential reason the windows/batch file will "skip" certain process? I do not find any error from the EventViewer or SQL Server log for that particular timestamp that possibly will lead to the issue.

Server Specification:

Windows Server 2016 Datacenter

Microsoft SQL Server 2017 (RTM-GDR) (KB5029375)

Please kindly share your thoughts if you experience this issue before. Appreciate that!

Answer 1

Hello John GanMY,

thank you for posting on the Microsoft Community Forums.

Based on the description, I understand that your issue is related to SQL Server.

Since there are no engineers dedicated to SQL Server in this forum. In order to be able to deal with your questions quickly and efficiently, I recommend that you repost your questions in the Q&A forum, where there will be a dedicated engineer to provide you with a professional and effective response.

Here is a link to the Q&A forum: https://learn.microsoft.com/en-us/answers/questions/

Have a nice day.

Best regards,

Lei

Answer 2

Hi,

Not sure if it is related to SQL Server or Windows batch file.

In my opinion, it is more on Windows batch file as the command did not get execute successfully.

Regards,

John