0

I am daily running a SQL Server Agent Job, which contains a ssis-project with a loop, which tries to do a task, but max 3 times. So it happens, that the task needs 2 tries, this is totally fine. But the SQL Server Agents gives back the information, that the Joob failed, but it didn't. It only should say "fail", when the the Loop fails 3 times. Any suggestions how to do it?

Kind regards,

jarlh
  • 42,561
  • 8
  • 45
  • 63
Whatamidoing
  • 25
  • 5
  • 1
    Sounds like you are trying to make a try catch... retry. You can consider using a script task to do this. This is an example for an email sending task but it could be anything. https://stackoverflow.com/questions/59576097/implement-send-mail-task-with-multiple-tries-in-case-if-its-failed-to-send-mail/59581372?noredirect=1#comment105421601_59581372 – KeithL Jan 07 '20 at 15:18
  • I do not have the skills to change the Execute Process Task to a script task – Whatamidoing Jan 07 '20 at 15:50
  • 1
    that's an easy one... https://www.dotnetperls.com/process – KeithL Jan 07 '20 at 15:57

2 Answers2

0
Change the setting of the  MaximumErrorCount  to 3
Red Devil
  • 2,343
  • 2
  • 21
  • 41
0

Would it be possible for you to upload the error messages given in the Failed Execution Report for that package?

Dulan Shaminda Manujaya
  • 11
  • 2