InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 02:24:21 GMT20http://www.sqlservercentral.com/Forums/Topic1406574-360-1.aspx[quote][b]M@hesh (1/13/2013)[/b][hr]Job is taking much time to execute, when i check the Wait type it shows 'Sleep_Task' and there is no blocking in the server.[/quote] it can, but for better help you need to tell following things.1) why/how do you think it is taking longer time ? how much time does it take regularly.2) it is frequantly or randomly ? or at any specfic time ? 3) what does it contain ? Stored proc / query ? if yes have you look into it ? Mon, 14 Jan 2013 03:07:54 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1406574-360-1.aspxHi,Job is taking much time to execute, when i check the Wait type it shows 'Sleep_Task' and there is no blocking in the server.could you please provide the sleep_task trouble shooting stepsThanks in AdvanceSun, 13 Jan 2013 22:58:23 GMTM@hesh