Thank you for the article. Sometimes the most difficult scenarios have the simplest solutions.

I've been trying to force a job to fail based on a query, and there it is: insert a string into integer field, brilliant. Plus, since I'm creating a new table, I can use this new table to track this job, and now I want to add more jobs to the list.