SQL Job Failing
-
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...
-
-
Thanks for looping back. SQL jobs are not in my wheelhouse any longer.