Hi Stephen/Dwayne I was trying the SQL statement, but the problem I have is; I do a Set Fields in a field, something like Please Wait... and then call the WAITFOR DELAY command, but instead of the field being set with the message frst and THEN the delay happening, the delay happens first and the message gets displayed afterwards!! completeley backwards! I tried doing with 2 seperate Active Links, no luck, it goes into the delay immediately, and displays the message afterwards. Any ideas? thanks a lot shafqat
Dwayne Martin <[EMAIL PROTECTED]> wrote: 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" >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: > Process: /opt/remedy/HelpDesk/pause 10 > 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" Shafqat Ayaz "Break the Rules, Forgive Quickly, Kiss Slowly, Love Truly, Laugh Uncontrollably, And Never Regret anything that made you Smile.." --------------------------------- Be a better Heartthrob. Get better relationship answers from someone who knows. Yahoo! Answers - Check it out. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
