Performing Completion Actions, Cursor_close_on_commit Setting

Hello,

I have several SQL Server jobs that execute procedures written to run
deletes and updates against tables in my data warehouse. Some jobs
occasionally get stuck with the status "Performing Completion Actions"
and can only be reset by restarting SQL Server or rebooting the
server.

I have seen one answer to this problem in a DTS package is to check
the box specifying "Close Connection on Completion" for each task. Is
this the equivalent of setting "cursor_close_on_commit" to "on" in
T-SQL?? If not, what is the equivalent in T-SQL??

Thanks in advance!

Cliff