Results 1 to 2 of 2

Thread: SQL SERVER JOBS FAILING

  1. #1
    sona Guest

    SQL SERVER JOBS FAILING

    I have created DTS packages to export data to text files....these packages are
    running...the jobs that are created to run these packages are failing ...
    both the SQL SERVER and the SQL SERVER AGENT are running administrator accounts ...if the job step is run on the command line it works..so basically
    some permission that invokes the the command shell is missing...jobs that run just T-SQL steps work fine too....what am i missing out?

  2. #2
    Ray Miao Guest

    SQL SERVER JOBS FAILING (reply)

    Where is the text file? If it's on remote server, you should use domain account to start sql services and job owner should be sa.


    ------------
    sona at 6/27/00 7:27:54 PM

    I have created DTS packages to export data to text files....these packages are
    running...the jobs that are created to run these packages are failing ...
    both the SQL SERVER and the SQL SERVER AGENT are running administrator accounts ...if the job step is run on the command line it works..so basically
    some permission that invokes the the command shell is missing...jobs that run just T-SQL steps work fine too....what am i missing out?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •