Let me explain in more detail..

I do have admin rights on the server.

The temp table is being created by a stored procedure

The stored proc is being executed by a sql agent job

the stored proc keeps failing half way through the code so i believe it never gets to drop the temp tables ..

So when the sql agent job completes or fails will it drop the temp tables ? Also how can i find the session id for the temporray tables in tempdb ? As those temp tables are created from different session which is not active anymore how do i kill it ?