Post reply

Cyclical forwarding detected

  • December 19, 2007 at 3:49 am

    #121503

    Hi there folks!

    I'm trying to execute a VBScript-Job using the SQL Agent in MSSQL Management Studio. The script is meant to start a program:

    [font="Courier New"]Set ShellWSH = CreateObject("WScript.Shell")

    ShellWSH.Run """c:\test.exe /param1=1 /param2=xy""", 3, True

    Set WshShell = Nothing

    [/font]

    Now I get an error message: [font="Courier New"]Cyclical forwarding detected[/font] ...

    What seems to be the problem?

    Thanks for your help!

    Dankwart

    --------------------------------------------------------
    [font="Comic Sans MS"]Correct me if I'm wrong[/font]

  • December 19, 2007 at 5:44 am

    #761356

    Add on:

    [font="Courier New"]Set ShellWSH = CreateObject("WScript.Shell")

    ShellWSH.Run """" & "notepad" & """" & "xy.txt", 1,false

    Set WshShell = Nothing[/font]

    I'm not quite sure if the "1,false" makes this difference - I guess it shouldn't. But now I got another problem nonetheless:

    The process notepad starts (as the task manager says) but no window is showing up. How come?

    Any ideas?

    --------------------------------------------------------
    [font="Comic Sans MS"]Correct me if I'm wrong[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply