Setting the LDAP failback time interval

The syntax for sp_ldapadmin set_failback_interval is:

sp_ldapadmin 'set_failback_interval', time_in_minutes

Where time_in_minutes is a value from -1 to 1440 minutes (24 hours).

• A value of 0 indicates that failing back is manual. That is, the housekeeper task does not attempt to automatically fails back the LDAP server. You must perform this task manually.

• A value of -1 sets the fail over time interval to 15 minutes, the default.

• If you issue sp_ldapadmin 'set_failback_interval' without any parameters, sp_ldapadmin displays the value to which the fail back interval is set.

• If you issue sp_ldapadmin without any parameters, sp_ldapadmin includes the failback time interval in the output:

•  sp_ldapadmin
  ----------------
  Primary:
  		URL:                 ''
  		DN Lookup URL:       ''
  		Access Account:      ''
  		Active:              'FALSE'
  		Status:              'NOT SET
  		StartTLS on Primary LDAP URL: 'TRUE'
  Secondary:
  		URL:                 ''
  		DN Lookup URL:       ''
  		Access Account:      ''
  		Active:              'FALSE'
  		Status:              'NOT SET'
  		StartTLS on Secondary LDAP URL: 'FALSE'
  	Timeout value:           '-1'(10000) milliseconds
  Log interval:            '3' minutes
  Number of retries:       '3'
  Maximum LDAPUA native threads per Engine: '49'
  Maximum LDAPUA descriptors per Engine: '20'
  Abandon LDAP user authentication when full: 'false'
  Failback interval:       '-1'(15) minutes
  (return status = 0)