March 26, 2009 at 3:08 am
I have moved sql services from Builtain\Administrator account to domain account having admin privilages after that i have restarted the services and deleted Builtain Account.
all dbs are online ok but the backup scheduled jobs and maintainance plans were failed,
I have taken db backups manuvally .it was success.
client told me create new jobs.
what is the solution for this .can i able to restart the failed jobs or create new jobs .
Pls let me what can i do .
March 26, 2009 at 3:13 am
Please let us know the error with which the jobs are failing. Also check the Start-up account for SQL Agent and the owner of the jobs have sufficient privileges.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
March 26, 2009 at 4:16 pm
Hi,
I have changed the owner of all jobs to Sa and then start the jobs .the jobs were completed successfully.
The issue was resolved .
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply