PROBLEM WITH THE SQL SERVER AGENT AND JOBS

• Amaury

  Mr or Mrs. 500

  Points: 546

  More actions

  May 5, 2005 at 6:15 pm

  #61133

  Hello everybody, regards!

  It happens that we have SQL SERVER 2000 and we have problems with the SQL SERVER AGENT, we have defined some jobs for running at night and making the database backups, but sometimes they don't run, so we have to do the backup manually. I'm not sure but I think it may be something related with the windows account is defined in the SQL SERVER AGENT.

  There are 2 accounts, ADMINISTRATOR (windows obviously) and SQLADMIN (which the site administrator created for me), previously the SQL SERVER AGENT had the ADMINISTRATOR account, and I had no problems usually, but now I have the problems, at this very moment it has the LOCAL ACCOUNT, sometimes I change it to SQLADMIN, I have problems!!! sometimes it runs, sometimes it doesn't, and something else: sometimes my partner, the site administrator, log on as ADMINISTRATOR into the server, sometimes I log on as SQLADMIN.

  I got confused so I want to know how it has to be, how should I log on into the server when I need it?, how should my partner log on into the server when he needs? does it affect when he logs on as ADMINISTRATOR? which is the account that has to be set up in the SQL SERVER AGENT?

  I'd appreciate a lot if any of you could help me a little with this matter...ok???

  Thanks a lot everyboy,

  Amaury, regards

  
  

  L.I. Amaury C.R.

• philcart

  SSC-Forever

  Points: 47796

  More actions

  May 5, 2005 at 9:36 pm

  #557265

  Firstly, please don't cross post.

  Secondly, see my response here,

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=180407

   

  --------------------
  Colt 45 - the original point and click interface