Is there any limitation on how many jobs we can add in trigger chain?

[sk]

Team,

We wanted to understand if there is any limitation in trigger chain on how many jobs we can add?

Use case is we have around 1000+ DB applications and we want to put all account import jobs in a trigger chain 

so wanted to understand if trigger chain can support those many jobs in one trigger chain or not?

[Sivagami · Accepted solution]

Hi @sk - From my experience of using triggerchain jobs, there is no limitation on the number of triggers you add to it but the field that stores the trigger values inside the triggerchain has data type. If it exceeds the datatype limit, the triggerchain jobs will fail with data too long errors. 

You may need to check the datatype of the field.

Try running below to check the datatype of the field externalconnection

desc ecmimportjob

select externalconnection,length(externalconnection) as maxlength from ecmimportjob order by maxlength desc limit 1

-Siva

[sk]

Thanks that makes sense

[pruthvi_t]

@sk ,

As @Sivagami mentioned, it depends on the datatype of the external connection field. If the trigger chain values exceeds the character limit then the trigger chain job will fail.

Thanks,