Cancelling a running sql command

I have a hangfire task that calls with a stored procedure(SqlCommand.ExecuteNonQuery… ).
This can run for several minutes.
Is there a way to cancel/abort the hangfire job or kill the thread while the c# code is waiting for the stored procedure to finish? If the thread could be killed, the connection would be broken and the sql execution will be stopped.
When using cancellationTokens i understand that i can only stop the task before or after the SqlCommand.ExecuteNonQuery command or am i missing something?.

You can use cancellationToken: