Background task time Out when run custom strode procedure

milana

Hi,

I have created a custom stored procedure and run through the background tasks. it takes 20 to 25 minutes to complete. Sometimes tasks fail due to the time out. when I manually run this procedure without any issue working fine.

in standard task working fine more than 30 minutes.

Please guide me on this.

Thank you

Milan

acl

sp runs faster in SQL? same parameters as what you see in the BG task history?