server time out issue (sql server Agent)

coool sweet 61 Reputation points
2021-01-12T21:16:45.64+00:00

hi ,

i have several job which is failing due to server time out issue.

sql severity of 0

below is the error:
environment reference id: NUll
execution timeout expired.The timeout period elapsed prior to completion of the operation or
the server is not responding.

what i want is automatically execute these jobs after failure, is there any way ssis store logs for this failed message and i can check and execute the job again automatically.

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,589 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Monalv-MSFT 5,901 Reputation points
    2021-01-13T01:42:41.723+00:00

    Hi @coool sweet ,

    1.What I want is automatically execute these jobs after failure
    We can set Retry attempts and Retry interval in Advanced Page of Job Step Properties.
    55963-retry.png

    2.Is is there any way ssis store logs for this failed message
    We can set ssis logging in sql agent job.
    55914-log1.png
    55915-log2.png

    Best Regards,
    Mona

    ----------

    If the answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.