Welcome to Sign in | Help

Re: executie job cu cmdExechttp://sqlserver.ro/forums/AddPost.aspx?PostID=2476

  •  08-14-2007, 6:14 PM

    Re: executie job cu cmdExechttp://sqlserver.ro/forums/AddPost.aspx?PostID=2476

    Salutare !

    Asta e continutul fisierului .bat : "C:\Test\Import.vbs"

     Fisierul Import.vbs arata asa:

    Const TagSettings = "ImportSettings"

    Dim  configFilePath

    configFilePath = CreateObject("Scripting.FileSystemObject").GetAbsolutePathName(".") & "\Import.config"

    Dim userName
    Dim xmlSchedConfig
    Dim xmlNode

     Set xmlSchedConfig = CreateObject("MSXML2.DOMDocument")
     xmlSchedConfig.load(configFilePath)
     Set xmlNode = xmlSchedConfig.selectSingleNode("/configuration/"& TagSettings &"/add[@key='" & "userName" & "']/@value")

    userName = xmlNode.Value

    Set FSOPaul = CreateObject("Scripting.FileSystemObject")
    Set filetxtPaul = FSOPaul.CreateTextFile("C:\Test\TestPaul.txt",True, False)

      filetxtPaul.WriteLine userName

    Set FSOPaul =nothing
    Set filetxtPaul =nothing 

     

     si fisierul Import.config :

    <?xml version="1.0" encoding="utf-8" ?>
    <configuration>
     
      <ImportSettings>
      
        <add key="userName" value="testuser"/>
     
      </ImportSettings>

    </configuration>

     

    Daca execut direct  Import.vbs  merge ....citeste din xml si scrie in fisierul text .

    Daca fac un job cu cmdexec si rulez un bat care cheama  Import.vbs   se blocheaza !!!!!!!!!!!!!!

    Daca ai timp sa incerci si tu ar fi perfect .... sper sa iti dai seama ce nu merge .

    ( faci tu modificarile de forldere si etc )

     

    Merci mult !

     

     

View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems