job failing

Hi,

After our server was moved two jobs running in our sql server since last couple of years have failed. (first job was doing the back up of production database and then restoring development database every night from that back & second job was backup and shrink transaction logs)

I checked job status history in sql server agent and I found these error messages.

(For first Job error message):The job failed. The owner () of job Truncate Log does not have server access.

(For second Job error message) : Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.

Owner of both the jobs is SA. I work remotely. All I can do is play from sql server enterprise manager. How can I solve this problem?

The error "owner of job does not have server access." is normally seen in case when the owner of job does not have login on the SQL Box.

You have mentioned that owner of job is SA, so i think the login should exist on SQL box, but can you double check for this login's existence ?

Gops Dwarak

|||Hi Gops,

Thanks for your reply.I'm not a dba.I work remotely & I've access to sql server from enterprise manager only. How can I check for this login SA's existence on SQL box?
|||Check under Security->Logins node|||Hi Gops,

I checked under security-logins. I do see SA over there with role as db_owner. when i clicked on securiy and then logins at that time i did see an error message saying that one or more databases are not accessible. The database which i'm trying to restore every night has a "loading" state and is not accessible at this moment.I know that has nothing to do with my jobs failing but just providing more information. Please let me know what can I do now.

Thank you|||This is not easy to figure unless we get to look at the box This is something support service can help you with. Thanks