I have an SQL trigger that returns an integer which I use for triggering a job. I have a condition set that triggers the job if the integer is greater than zero. However, this trigger seems to deactivate itself a few minutes after I configure it and hit ok on the UI. If i simply click on job to "Edit Job" and then hit ok, and the the trigger becomes active again. I am running another job with a similar SQL trigger and it stays active just fine.

I checked the log and it says "A trigger was inactivated due to an error: Input string was not in the correct format."

Any insight is greatly appreciated.