question

HenryMa-9048 avatar image
0 Votes"
HenryMa-9048 asked HenryMa-9048 commented

sp_start_job semaphore timeout error

I have a job called "Henryjoba". I'm trying to call that job via sp_start_job, but it's erroring out with
"Msg 121, Level 20, State 0, Line 2
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The semaphore timeout period has expired.)"

Here is my SQL:
USE msdb ;
GO

EXEC dbo.sp_start_job N'Henryjoba' ;
GO

Any ideas what I'm missing?

thanks!

sql-server-generalsql-server-transact-sql
· 3
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

As they say, interesting.

Have you checked if the job starts nevertheless?

What happens if you attempt to start the job through Object Explorer?

What happens if you schedule it?

When you run the above, are you running SSMS on the same machine as where SQL Server is installed, or do you connect over the network?

0 Votes 0 ·

Hi @HenryMa-9048,

Any update for this thread? Could you share us the information that Erland mentioned? And did this is a remote connection to run the job?

0 Votes 0 ·

Sorry for the late response, got swamped and forgot to update. I'm not sure if it is a version thing, but we upgraded our SQL Server from 2012 to 2019 and it works now!

0 Votes 0 ·

0 Answers