title: Get the Session ID of a SQL Server Job Submitted from .net
body: <p>I'd like to add the facility to kill a SQL Server job from a .NET application. The job would be some sort of complex insert or update statement and the way I am doing it, it will run in the background. Once submitted I'd like the facility to kill it in case it's using up too much resource\taking too long etc. So my idea is just to kill the job using the SQL Server Session id, but how do I get this and can I get this at submission time?</p>