Post reply

Windows 2003 and Sql Agent Jobs Getting Suspended.

  • September 6, 2005 at 6:01 pm

    #152534

    I have the following sample ActiveX Script

    Dim filesys, filetxt

    Const ForReading = 1, ForWriting = 2, ForAppending = 8

    Set filesys = CreateObject("Scripting.FileSystemObject")

    Set filetxt = filesys.OpenTextFile("c:\somefile.txt", ForAppending, True)

    filetxt.WriteLine("Your text goes here.")

    filetxt.Close

    SET fileTxt = Nothing

    SET filesys = Nothing

    I can set this to run as a job on a Windows 2000 Standard Server w/ Sql Server 2000 SP4, and it runs as a domain User.

    If I setup this same job on a Windows 2003 Standard Server w/ Sql Server 2000 SP4, My job never runs, instead it is suspended...

    This same domain user is an admin user on both servers... has anyone else ran into this issue before??

    -- Francisco

  • September 9, 2005 at 8:00 am

    This was removed by the editor as SPAM

  • September 9, 2005 at 11:44 am

    #588827

    I am not sure the reason. Can you check the running account of the sql server on w2003 machine? Does this account have permission to access/create the file in the destination folder?

     

  • September 9, 2005 at 7:12 pm

    #588945

    The account that runs the SqlService is the same domain user that runs the Agent service, this domain user is admin on the w2003 server.

    -- Francisco

Viewing 4 posts - 1 through 3 (of 3 total)

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