help! error 14258

[chloe]

hello.

uhm.
i'm making this scheduled job that will automatically send emails after a given interval. i'm trying to connect to the agent and start the jobserver but
i'm getting this error 14258 w/c says:

cannot perform this operation while sqlserveragent is starting.try again later...

i don't know why i get this error... i went to this site that said that i should only use the thread mode. whatever that is, i checked the sqlserver log and confirmed that i am in the said mode.

pls help me save my sanity...

thank you very much.

[skhanal]

Are you starting agent and sending email from the same job?. May be you have to wait for sometime to let the agent start before attempting to send the email.

[rmiao]

Ensure sql agent service is running on the server.

[dim]

Do you have the following message in your SQL Agent log file?

"Waiting for SQL Server to recover databases."

and also check if the next option is enabled on your server:

1) Right click on the server name -> Properties
2) Processor tab
3) "Use Windows NT fibers" checkbox

Thx,
Dim