Changing Schedule on sys_trigger for "Cancel Expired Assessments"

[robertyoung]

We want to run this guy every day. Tried to change it right in sys_trigger and got mixed results. seemed to work in one instance but not another.

Do you guys know the preferred way to change a scheduled job that exists only in sys_trigger? I think what may be going on is that the current run just hasn't happened yet so the new duration hasn't taken over.

Not sure how to run a scheduled job straight out of the trigger table, there is not an "Execute Now"

[robertyoung]

merbs, I was not able to force the waiting job to execute. We just ended up waiting. The new instance in sys_trigger DID have the updated schedule though so there is that up side.

I ended up planning the production implementation around when the job was scheduled to run.

This was a long time ago so I don't remember a ton of detail but you *may* be able to submit the job from the scheduled jobs form to get a new instance into sys_trigger. I would assume I tried that and that it didn't work but I just don't remember details.