Hello,
I have a SQL command inside a procedure:
SET @cmd='start /WAIT C:\Go.vbs'
EXEC master..xp_cmdshell @cmd;
The script just run this code:
set iim1= CreateObject ("imacros")
iret = iim1.iimOpen ()
iret = iim1.iimPlay("C:\NBA.iim")
If I run the script manually works fine.
If I execute the script through the SQL procedure, then the iMacro gets stuck on the line
URL GOTO=http://www.NBA.com
What I am making wrong?
Daniel
IMacro stuck when ran from SQL xp_cmdshell
Forum rules
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
iMacros EOL - Attention!
The renewal maintenance has officially ended for Progress iMacros effective November 20, 2023 and all versions of iMacros are now considered EOL (End-of-Life). The iMacros products will no longer be supported by Progress (aside from customer license issues), and these forums will also no longer be moderated from the Progress side.
Thank you again for your business and support.
Sincerely,
The Progress Team
Before asking a question or reporting an issue:
1. Please review the list of FAQ's.
2. Use the search box (at the top of each forum page) to see if a similar problem or question has already been addressed.
3. Try searching the iMacros Wiki - it contains the complete iMacros reference as well as plenty of samples and tutorials.
4. We can respond much faster to your posts if you include the following information: CLICK HERE FOR IMPORTANT INFORMATION TO INCLUDE IN YOUR POST
-
- Posts: 3834
- Joined: Mon May 31, 2010 4:59 pm
Re: IMacro stuck when ran from SQL xp_cmdshell
Hi Scout2Win,
Is the Go.vbs script running in an interactive user session? It might be that this site does not load/work well unless it is running in such a session, e.g. under a user account that is logged in and has an active desktop.
For more information, Please see this article.
Is the Go.vbs script running in an interactive user session? It might be that this site does not load/work well unless it is running in such a session, e.g. under a user account that is logged in and has an active desktop.
For more information, Please see this article.
Regards,
Tom, iMacros Support
Tom, iMacros Support