Error on Scheduled Jobs Unable to determine if the owner .....

• Domenico Buccelli

  Grasshopper

  Points: 16

  More actions

  February 15, 2006 at 9:22 am

  #111687

  Hy all,

  I have two a job failed with this message:

  The job failed.  Unable to determine if the owner (FLSRVF1\Administrator) of job Optimizations Job for DB Maintenance Plan 'DB Maintenance Plan1' has server access

  (reason: Impossibile ottenere informazioni relative al gruppo/utente di Windows NT 'FLSRVF1\Administrator'. [SQLSTATE 42000] (Error 8198)).

   

  I know the reason of this problem: Network Administrator of my cusotmer change the name of the server who

  created the job...I've tryed to delete the job also with Enterprise Manager also directly using the stored procedure 'sp_delete_job' but I can't (I think for the same reason my job failed).

  There is some way for delete or modify the job server owner name?

   

  Thanks

  Domenico

• Krishnan Kaniappan

  Ten Centuries

  Points: 1051

  More actions

  February 15, 2006 at 9:42 am

  #621092

  Enterprise manager->Management->SQL Server Agent-> jobs->Right click on the job->properties->general tab->Owner drop down....

  thx,

  krishnan kaniappan

  -Krishnan