I have a job run through rt-crontool that changes any stalled tickets which haven’t been touched in 7 days to ‘open’. The job works perfectly, but it also updates the ticket’s LastUpdated value when it runs. This causes my other job, which checks for ticket activity, to skip the recently re-opened tickets. It also causes the relative date I use in my email template to say “0 seconds” instead of the actual date on which the ticket was last modified.
How can I make the transaction this job generates be ignored? I want it to run as it does now, but for the ticket’s LastUpdated value to remain where it was before my job touched the ticket. Is this even possible? Thanks in advance.