SQL Server Performance Forum – Threads Archive
Cannot perform ,while sql server agent is startingWhen I clicked the finished button after creating a new maintenance plan I got the following error"Cannot perform this operation while sql server agent is starting".What to do in this case so that I can assign the maintenance plan without any such interrupts
Ensure to restart SQLAgent whenever any job is scheduled to execute, and on the SQLagent properties mark the ‘Restart SQLAgent if it is stopped unexpectedly’ option to avoid this hassle. Also ensure the account used for SQLAgent has required privileges to handle the operations.
Refer to the sql server error log and SQlAgent log for any information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.