johnnyg123
asked on
sql job timeout
We had have a job that executes a stored proc that has been working fine
(the stored proc executes a query that involves a table on a linked server)
The job started failing saying there was a schema change
I was out of the office and a colleague said he redid the linked server connection (not sure why) which got rid of that error but now there is a time out error
What is strange is that if the stored proc executed by job is manually executed it runs fine but when scheduled in the job it times out. Not sure what the difference would be
(the stored proc executes a query that involves a table on a linked server)
The job started failing saying there was a schema change
I was out of the office and a colleague said he redid the linked server connection (not sure why) which got rid of that error but now there is a time out error
What is strange is that if the stored proc executed by job is manually executed it runs fine but when scheduled in the job it times out. Not sure what the difference would be
My initial thought is that in a query browser there is no timeout, but _PERHAPS_ scheduled jobs make a connection to the server like vb apps do with a timeout in the connection string or something.
Check permissions. Maybe the user the job runs as does not have the same permissions on the newly created linked server. i.e., make sure the new setup matches what you had before.
Oh, here we go:
source: http://msdn.microsoft.com/en-us/library/ms189727.aspx
Shutdown time-out interval (in seconds)
Specifies the number of seconds that SQL Server Agent waits for jobs to complete before shutting down. If the job is still running after the interval specified, SQL Server Agent forcefully stops the job.
source: http://msdn.microsoft.com/en-us/library/ms189727.aspx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
None of the posted solutions was the correct answer