Any failed tasks should sit in pending after 5 retries - Job advanced query(SQL)configuration

[Shanthi_Katkam]

There's a requirement where any failed tasks should sit in pending after 5 retries, which should not process the task if they have the number of retries as >=5. 

Someone please provide me an advanced query (SQL).

[Amit_Malik]

Security system has this setting 

If you still want those in pending but job wont pick, thn below is the query in advance config of wsretry job

and at.provisioningtries <=5

[Shanthi_Katkam]

Thanks for the sharing the details. 
I am also looking for the specific security system (Ex: 9,10,11,12) and status key not in (3,4,8,9). 

[Amit_Malik]

and at.provisioningtries <=5 and at.status='3'

security system , you can select in BASIC

[NM]

@Shanthi_Katkam apply the same filter for status .. at.staus in ('3')

[rushikeshvartak]

@Shanthi_Katkam  Please use below configuration

and at.provisioningtries <=5 and at.SECURITYSYSTEM in (9,10,11,12) and at.status not in (3,4,8,9)

You don't need to add status condition as WSRETRY only consider 1 = New Tasks