Results 1 to 5 of 5
  1. #1
    Join Date
    Dec 2003
    Posts
    2

    Unanswered: Can't schedule a job to run a package

    I have schedule a job to run a package but it failed on cmd.exe....I am not a sys_admin....

    Please let me know if I have to be a sys_admin or not?

  2. #2
    Join Date
    Dec 2003
    Posts
    4
    If its scheduled then the MS Agent Service must be running under a domain account and any resources this package utlises must be accessible by this domain account

  3. #3
    Join Date
    Feb 2002
    Posts
    2,232
    Are you scheduling the job within sql server or the os ?

  4. #4
    Join Date
    Dec 2003
    Posts
    2
    I try to schedule it with SQL not OS.

  5. #5
    Join Date
    Feb 2002
    Posts
    2,232
    it failed on cmd.exe
    Can you be more specific about this ?

Posting Permissions

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