Error 22022

I'm attempting to create a backup schedule for my SQL
Server 2000, and I have created the job to perform the
backups. But, when I try to run the backup to test it, I
get the following error:
Error 22022: SQLServerAgent is not currently running so it
cannot be notified of this action.
I have checked, SQLServerAgent is running and if I stop
and start SQLServerAgent I get the same error.
What is wrong and how do I fix it?Some things to check - Are you running SQL Server in fiber
mode (lightweight pooling)? Have you ensured that SQL Agent
is truly running and not hung up in a starting status? Have
you checked your sqlagent.out file?
In addition to lightweight pooling being enabled, Agent can
also get hung up due to a bad mail profile.
-Sue
On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
>I'm attempting to create a backup schedule for my SQL
>Server 2000, and I have created the job to perform the
>backups. But, when I try to run the backup to test it, I
>get the following error:
>Error 22022: SQLServerAgent is not currently running so it
>cannot be notified of this action.
>I have checked, SQLServerAgent is running and if I stop
>and start SQLServerAgent I get the same error.
>What is wrong and how do I fix it?|||Thanks Sue for your reply. I have checked and SQL Mail is
not configured, but I have checked on an older NT systems
and its SQL Mail is not configured either and the backups
work fine. My current system is Windows 2003 server,
could this be causing the problem? Also, is there a way
to configure MSServerAgent to not bother with mail? I
would rather have it configured so no mail is sent out.
Ciao,
Rob.
>--Original Message--
>Some things to check - Are you running SQL Server in fiber
>mode (lightweight pooling)? Have you ensured that SQL
Agent
>is truly running and not hung up in a starting status?
Have
>you checked your sqlagent.out file?
>In addition to lightweight pooling being enabled, Agent
can
>also get hung up due to a bad mail profile.
>-Sue
>On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
><anonymous@.discussions.microsoft.com> wrote:
>>I'm attempting to create a backup schedule for my SQL
>>Server 2000, and I have created the job to perform the
>>backups. But, when I try to run the backup to test it,
I
>>get the following error:
>>Error 22022: SQLServerAgent is not currently running so
it
>>cannot be notified of this action.
>>I have checked, SQLServerAgent is running and if I stop
>>and start SQLServerAgent I get the same error.
>>What is wrong and how do I fix it?
>.
>|||If you don't set a mail profile for SQL Agent then it won't
do anything with mail.
In terms of SQL Agent, you still need to check if the
service is actually running (vs starting), if your server is
configured for lightweight pooling and you need to check
your sqlagent.out file for any errors or problems in
starting SQL Agent.
-Sue
On Wed, 12 May 2004 10:12:18 -0700, "Rob Simac"
<anonymous@.discussions.microsoft.com> wrote:
>Thanks Sue for your reply. I have checked and SQL Mail is
>not configured, but I have checked on an older NT systems
>and its SQL Mail is not configured either and the backups
>work fine. My current system is Windows 2003 server,
>could this be causing the problem? Also, is there a way
>to configure MSServerAgent to not bother with mail? I
>would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
>>--Original Message--
>>Some things to check - Are you running SQL Server in fiber
>>mode (lightweight pooling)? Have you ensured that SQL
>Agent
>>is truly running and not hung up in a starting status?
>Have
>>you checked your sqlagent.out file?
>>In addition to lightweight pooling being enabled, Agent
>can
>>also get hung up due to a bad mail profile.
>>-Sue
>>On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
>><anonymous@.discussions.microsoft.com> wrote:
>>I'm attempting to create a backup schedule for my SQL
>>Server 2000, and I have created the job to perform the
>>backups. But, when I try to run the backup to test it,
>I
>>get the following error:
>>Error 22022: SQLServerAgent is not currently running so
>it
>>cannot be notified of this action.
>>I have checked, SQLServerAgent is running and if I stop
>>and start SQLServerAgent I get the same error.
>>What is wrong and how do I fix it?
>>.|||Hello Rob,
Did you ever get this problem figured out? I'm having the exact same issue and I have verified that SQL Agent is running but still having the error.
Let me know.
Regards,
-greg
"Rob Simac" wrote:
> Thanks Sue for your reply. I have checked and SQL Mail is
> not configured, but I have checked on an older NT systems
> and its SQL Mail is not configured either and the backups
> work fine. My current system is Windows 2003 server,
> could this be causing the problem? Also, is there a way
> to configure MSServerAgent to not bother with mail? I
> would rather have it configured so no mail is sent out.
> Ciao,
> Rob.
> >--Original Message--
> >Some things to check - Are you running SQL Server in fiber
> >mode (lightweight pooling)? Have you ensured that SQL
> Agent
> >is truly running and not hung up in a starting status?
> Have
> >you checked your sqlagent.out file?
> >In addition to lightweight pooling being enabled, Agent
> can
> >also get hung up due to a bad mail profile.
> >
> >-Sue
> >
> >On Tue, 11 May 2004 11:04:14 -0700, "Rob Simac"
> ><anonymous@.discussions.microsoft.com> wrote:
> >
> >>I'm attempting to create a backup schedule for my SQL
> >>Server 2000, and I have created the job to perform the
> >>backups. But, when I try to run the backup to test it,
> I
> >>get the following error:
> >>
> >>Error 22022: SQLServerAgent is not currently running so
> it
> >>cannot be notified of this action.
> >>
> >>I have checked, SQLServerAgent is running and if I stop
> >>and start SQLServerAgent I get the same error.
> >>
> >>What is wrong and how do I fix it?
> >
> >.
> >
>