The "set fields" option worked! In the active link I set a display field to equal "$PROCESS$ @@:/opt/remedy/HelpDesk/pause 3". (Anything over 3 seconds and the action would time out.) The filter was the same but without the "@@:". In both cases the hour glass displayed for three seconds then I got the message.
I tried Stephen's "WAITFOR DELAY '00:00:10'" option, but I got "invalid SQL statement". Is that an Oracle statement? I looked in my Oracle book but can't find any "wait" command. Anyway, Thank you Stephen and Fred. You've solved my problem. Dwayne Martin ---- Original message ---- >Date: Thu, 9 Aug 2007 16:46:02 -0400 >From: "Heider, Stephen" <[EMAIL PROTECTED]> >Subject: Re: Inserting pause in workflow >To: arslist@ARSLIST.ORG > >Another option is to use your RDBMS. For SQL Server, > >Set Fields SQL > WAITFOR DELAY '00:00:10' > >Stephen > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Grooms, Frederick W >Sent: Thursday, August 09, 2007 4:43 PM >To: arslist@ARSLIST.ORG >Subject: Re: Inserting pause in workflow > >Do the PROCESS inside of a Set Fields Action > >A Run Process action does not wait. A PROCESS inside of a Set Fields >action waits for the external program to complete. > >Fred > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Kaiser Norm E CIV USAF 96 >CS/SCCE >Sent: Thursday, August 09, 2007 3:23 PM >To: arslist@ARSLIST.ORG >Subject: Re: Inserting pause in workflow > >I could be mistaken about this, but I believe the way it works is, when >Remedy runs an external process, it does NOT wait for the external >process to finish executing before it continues workflow processing. > >-----Original Message----- >From: Action Request System discussion list(ARSList) >[mailto:[EMAIL PROTECTED] On Behalf Of Dwayne Martin >Sent: Thursday, August 09, 2007 3:05 PM >To: arslist@ARSLIST.ORG >Subject: Inserting pause in workflow > >Hello Everyone, > >(ARS 7.01 patch 2, Linux server, Oracle 10.2 db) > >How do you insert a pause in an active link or a filter? > >I have heard that you should run a process then call that process. So I >have a "pause" program on our server that says "sleep $1". On the >server if I enter "/opt/remedy/HelpDesk/pause 10" it waits ten seconds >then returns the cursor. > >So I set up both an active link and a filter to do the "pause 10" >command then send a message. >The active link does a "Run Process" of "@@:/opt/remedy/HelpDesk/pause >10". The filter is the same but without the "@@:". In both cases I get >the message right away. > >The active link log shows: ><ACTL> Process: /opt/remedy/HelpDesk/pause 10 ><ACTL> Success > >The filter has a "`!" after it to make it run in phase 1, and the filter >log shows it running before the message, but the message still appears >right away. > >What am I doing wrong? > >Is there a better way of solving this altogether? It seems like pausing >is such a normal thing to do that there should be a built-in Remedy >function. > >Dwayne Martin >Computing Support >James Madison University > >________________________________________________________________________ >_______ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where >the Answers Are" > >_______________________________________________________________________________ >UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the >Answers Are" Dwayne Martin Computing Support James Madison University _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
