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.
2.Is is there any way ssis store logs for this failed message
We can set ssis logging in sql agent job.
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.