URGENT - SQLAgent not autostarting

  • Oh yeah, one more thing. If we close the box the service doesn't start.

    Sandy Schaefer


    Sandy Schaefer

  • The service shouldn't need to interact with the desktop. Question: are the binaries for SQL Server stored on a drive local to the computer?

    K. Brian Kelley

    bkelley@sqlservercentral.com

    http://www.sqlservercentral.com/columnists/bkelley/

    K. Brian Kelley
    @kbriankelley

  • We're trying to run an .exe from a SQLAgent job. The exe hangs when we use cmdshell but doesn't with it's through a DTS package. However, for the DTS package to run the service seems to be need to be set to interact with the desktop. Otherwise it completely bombs. Sorry to have to ask this but what are "binaries for SQL Server"?

    Sandy Schaefer


    Sandy Schaefer

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

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