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:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> >Reply-To: "User questions and discussions about OTRS.org" ><[email protected]> >To: "User questions and discussions about OTRS.org" <[email protected]> >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
_______________________________________________ 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/
