What error do you get?
Some tips:
'If i = cYes Then' is more clear than 'If i = 6 Then'.
It is better to use a parameterized query:
Code:
cmd.<a href="http://www.basic4ppc.com/help/sql/index.html?addparameter" target="_blank">AddParamter</a>("Value1")
cmd.CommandText = "Delete From Jobs Where JobName = @value1"
cmd.SetParameter("Value1",ListJobs.Text)
cmd.ExecuteNonQuery