locked
SQL JOB Error: RRS feed

  • Question

  • Hi,

    Daily we are making email campaigns.This is the procedure.

    We having sql job (Automatically create when users are making Campaign through web interface).At step2 it will invoke remote.bat file then this remote.bat file will invoke line below.

    Here database server name is : SQLtest01

    Remote server name is : powersrv (Which contains .wsf file)

    (\\SQLtest01\services\ExecuteRemoteScript.bat "\\powersrv\services\CS.wsf //T:60000 //H:CScript //nologo //job:emailmembers email $select * from CPpp_Public.TEMP_EmailCampaign_8052 WHERE ActiveFlag = 1$ 8052" sqltest01)

     

    The problem here is some time it working some times getting below error:

    Please help me

     

    Message
    Executed as user: TTDC\sql2k5admin1.. C:\WINDOWS\system32>cscript.exe \\SQLtest01\services\ExecuteRemoteScript.wsf "\\powersrv\services\CS.wsf //T:60000 //H:CScript //nologo //job:emailmembers email $select * from CPpp_Public.TEMP_EmailCampaign_8000 WHERE ActiveFlag = 1$ 8052" queenanne   Microsoft (R) Windows Script Host Version 5.6  Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.    CommandLine = \\powersrv\services\CS.wsf //T:60000 //H:CScript //nologo //job:emailmembers email "select * from CPpp_Public.TEMP_EmailCampaign_8000 WHERE ActiveFlag = 1" 8052  remoteMachineName = PowersrvCurrent Status is 0  Current Status is 1  The script has started on the remote machineAn error has occurred  Description: Can not find script file "\\powersrv\services\CS.wsf".  Line Number: 0  Character: 0  Source: Windows Script Host Remote Script  Source Text:   Number: -2147467259 (Hex: -2147467259.  Process Exit Code -2147467259.  The step failed.

    Tuesday, December 14, 2010 11:14 AM

Answers

  • you need to add more debugging message to find out why you get "Can not find script file" as this is not normal OS error or SQL Error.
    Intermittent network issues?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, December 14, 2010 3:28 PM

All replies

  • Error says "Can not find script file"


    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, December 14, 2010 11:31 AM
  • Yes,

     

    But if you keep on try just for 2nd or 3rd attempt it got success.

    If you see above my matter they i specified The problem here is some times it working some times getting .Every time we are not getting the problem.

    Tuesday, December 14, 2010 3:16 PM
  • you need to add more debugging message to find out why you get "Can not find script file" as this is not normal OS error or SQL Error.
    Intermittent network issues?
    Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other user's find a solution quicker
    --------------------------------------------------------------------------------
    This posting is provided "AS IS" with no warranties, and confers no rights.
    --------------------------------------------------------------------------------
    My Blog: http://blogs.msdn.com/blakhani
    Team Blog: http://blogs.msdn.com/sqlserverfaq
    Tuesday, December 14, 2010 3:28 PM