Just to further update, and now makes sense, is that the SQL trigger still sends an email when i go to the job and save without Inactivating. Basically, it looks now like you changed the functionality on all the triggers except the SQl which is still performing the way all of them used to.