I understand the SQL that your doing here, the part that I'm foggy about is how to get this to run as a generic agent job. -----Original Message----- From: Zhang Wayne [mailto:waynezhang72@hotmail.com] Sent: Thursday, March 01, 2007 10:39 PM To: Dave Wojciechowski Subject: RE: [otrs] Generic Agents Step1: Get agent id that need watch ticket not closed over one days select id from system_user where login = :@Agent_Name Step2: Clean the watch list under monitor list delete from ticket_watcher where user_id = :@system_user.id Step3: Insert ticket id that need watch under monitor list insert into ticket_watcher select ticket.id, :@system_user.id , sysdate(), 1, sysdate(), 1 from ticket, ticket_state where ticket.ticket_state_id = ticket_state.id and ticket_state.type_id <> 3 and ticket_state.type_id <> 7 and ticket.create_time <= date_format(adddate(sysdate(),INTERVAL -1 DAY),'%Y-%m-%d 00:00:00') @Agent_Name and @system_user.id are parameters that need replace it, coul dyou understand it?

From: "Dave Wojciechowski" Reply-To: "User questions and discussions about OTRS.org" To: "User questions and discussions about OTRS.org" Subject: [otrs] Generic Agents Date: Tue, 27 Feb 2007 20:19:12 -0500

Hopfully somone has done this before and can help me w/ this, i'm looking for a way to make all ticket that remain open for more than one day be automatically subscribed to for a agent to watch in watch tickets. Anyone done that b4.

_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/

_________________________________________________________________ 免费下载 MSN Explorer: http://explorer.msn.com/lccn