ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    SQL Job Failing

    IT Discussion
    sql server
    2
    3
    822
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • IRJI
      IRJ
      last edited by

      I created a new job, when I try to kick it off I get this :

      The job failed. The owner (mydomain\sqluser1) of job "jobname" does not have server access.

      I am able to kick off the job under an admin account, but I am trying to schedule this job using "sqluserq" I would like to make this account a sysadmin so I ran this command:

      exec sp_addsrvrolemember 'mydomain\sqluser1', 'sysadmin';

      Even after running that command, the job is still failing...

      1 Reply Last reply Reply Quote 4
      • IRJI
        IRJ
        last edited by

        Resolution below

        community.spiceworks.com/topic/1251465-sql-job-failing-because-owner-does-not-have-server-access?page=1&source=homepage-feed#entry-5153204

        1 Reply Last reply Reply Quote 1
        • scottalanmillerS
          scottalanmiller
          last edited by

          Thanks for looping back. SQL jobs are not in my wheelhouse any longer.

          1 Reply Last reply Reply Quote 1
          • 1 / 1
          • First post
            Last post