Re: Error 14258

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Ron Hinds (__NoSpam_at___NoSpamramac.com)
Date: 09/02/04 

Date: Thu, 2 Sep 2004 09:13:50 -0700

OK I've stopped and restarted the service several times. Event Viewer claims
the service started succesfully. Where else can I look for errors? The SQL
Server logs show no errors with the Agent. But you are correct - the jobs
are NOT running! Any other sugggestions on where to look for the problem?

"DeeJay Puar" <deejaypuar@Yahoo.com> wrote in message
news:393601c48f89$d0181ff0$a501280a@phx.gbl...
> Hi,
>
> The SQLServerAgent has NOT started properly after a
> shutdown/reboot two days ago. If you look at the service
> manager, the service appears to have started, but its
> really not.
>
> Here is what you have to do:
>
> Stop the SQLServerAgent (Not SQL Server)
> Restart the service (make no errors are recorded)
>
> Here is something else you may have not noticed, since
> this error has been occurring, your scheduled jobs have
> not run. You might want to backup your databases and run
> any other jobs you may have.
>
> hth
>
> DeeJay
> >-----Original Message-----
> >For the last two days I've been getting this error
> whenever I click on a Job
> >in Enterprise Manager:
> >
> >Error 14258: Cannot perform this operation while
> SQLServerAgent is starting.
> >Try again later.
> >
> >Any idea what is causing this? Agent appears to be
> running - it is
> >performing the assigned tasks on schedule.
> >
> >
> >.
> >

Relevant Pages