begin tran instead of use db_name inside a SQL Job for executing Stored Procedure
When you do that in a job it basically ends the session and rolls back the transaction when the job finishes.  You can trace that using SQLTransaction event class in Profiler.
That's the reason why you do not see any open transaction/sessions or the work being done.