Database Maintenance

I've set up a database maintenance plan in Enterprise
manager, but it seems none of the jobs are running. What
am I missing?
ThanksIn the jobs screen in EM.
Is the Job Enabled ?
Is the Schedule Enabled ?
Is it working but simply failed ?
How do you know/think it isn't running?
Is SQL Server Agent started ?
--
--
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org
"Mike D" <anonymous@.discussions.microsoft.com> wrote in message
news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
> I've set up a database maintenance plan in Enterprise
> manager, but it seems none of the jobs are running. What
> am I missing?
> Thanks|||Is SQL Server Agent started?
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Mike D" <anonymous@.discussions.microsoft.com> wrote in message
news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
> I've set up a database maintenance plan in Enterprise
> manager, but it seems none of the jobs are running. What
> am I missing?
> Thanks|||Yes
Yes
No
I'm not finding updated database backups in the backups
directory
NO
>--Original Message--
>In the jobs screen in EM.
>Is the Job Enabled ?
>Is the Schedule Enabled ?
>Is it working but simply failed ?
>How do you know/think it isn't running?
>Is SQL Server Agent started ?
>--
>--
>Allan Mitchell (Microsoft SQL Server MVP)
>MCSE,MCDBA
>www.SQLDTS.com
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>"Mike D" <anonymous@.discussions.microsoft.com> wrote in
message
>news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
>> I've set up a database maintenance plan in Enterprise
>> manager, but it seems none of the jobs are running. What
>> am I missing?
>> Thanks
>
>.
>|||No, it wasn't running and when I try to start it I get the
message:
Could not start the sqlserveragent service on local
computer. The service did not return an error. This could
be an internal windows error or an internal service error.
>--Original Message--
>Is SQL Server Agent started?
>--
>Tibor Karaszi, SQL Server MVP
>Archive at: http://groups.google.com/groups?
oi=djq&as_ugroup=microsoft.public.sqlserver
>
>"Mike D" <anonymous@.discussions.microsoft.com> wrote in
message
>news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
>> I've set up a database maintenance plan in Enterprise
>> manager, but it seems none of the jobs are running. What
>> am I missing?
>> Thanks
>
>.
>|||Check to ensure the login and password that the agent runs under is correct.
--
Andrew J. Kelly SQL MVP
"Mike D" <anonymous@.discussions.microsoft.com> wrote in message
news:000a01c3c4af$f3a9ac90$a101280a@.phx.gbl...
> No, it wasn't running and when I try to start it I get the
> message:
> Could not start the sqlserveragent service on local
> computer. The service did not return an error. This could
> be an internal windows error or an internal service error.
>
> >--Original Message--
> >Is SQL Server Agent started?
> >
> >--
> >Tibor Karaszi, SQL Server MVP
> >Archive at: http://groups.google.com/groups?
> oi=djq&as_ugroup=microsoft.public.sqlserver
> >
> >
> >"Mike D" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
> >> I've set up a database maintenance plan in Enterprise
> >> manager, but it seems none of the jobs are running. What
> >> am I missing?
> >>
> >> Thanks
> >
> >
> >.
> >|||It was under the Local System account. I switched it to an
admin account, but I got the same error when trying to
start it.
>--Original Message--
>Check to ensure the login and password that the agent
runs under is correct.
>--
>Andrew J. Kelly SQL MVP
>
>"Mike D" <anonymous@.discussions.microsoft.com> wrote in
message
>news:000a01c3c4af$f3a9ac90$a101280a@.phx.gbl...
>> No, it wasn't running and when I try to start it I get
the
>> message:
>> Could not start the sqlserveragent service on local
>> computer. The service did not return an error. This
could
>> be an internal windows error or an internal service
error.
>>
>> >--Original Message--
>> >Is SQL Server Agent started?
>> >
>> >--
>> >Tibor Karaszi, SQL Server MVP
>> >Archive at: http://groups.google.com/groups?
>> oi=djq&as_ugroup=microsoft.public.sqlserver
>> >
>> >
>> >"Mike D" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
>> >> I've set up a database maintenance plan in Enterprise
>> >> manager, but it seems none of the jobs are running.
What
>> >> am I missing?
>> >>
>> >> Thanks
>> >
>> >
>> >.
>> >
>
>.
>|||You might want to give MS PSS a call so they can work directly with you.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;sql SQL Support
http://www.mssqlserver.com/faq/general-pss.asp MS PSS
--
Andrew J. Kelly SQL MVP
"Mike D" <anonymous@.discussions.microsoft.com> wrote in message
news:063801c3c4b9$4cd9ec90$a001280a@.phx.gbl...
> It was under the Local System account. I switched it to an
> admin account, but I got the same error when trying to
> start it.
> >--Original Message--
> >Check to ensure the login and password that the agent
> runs under is correct.
> >
> >--
> >Andrew J. Kelly SQL MVP
> >
> >
> >"Mike D" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:000a01c3c4af$f3a9ac90$a101280a@.phx.gbl...
> >> No, it wasn't running and when I try to start it I get
> the
> >> message:
> >> Could not start the sqlserveragent service on local
> >> computer. The service did not return an error. This
> could
> >> be an internal windows error or an internal service
> error.
> >>
> >>
> >> >--Original Message--
> >> >Is SQL Server Agent started?
> >> >
> >> >--
> >> >Tibor Karaszi, SQL Server MVP
> >> >Archive at: http://groups.google.com/groups?
> >> oi=djq&as_ugroup=microsoft.public.sqlserver
> >> >
> >> >
> >> >"Mike D" <anonymous@.discussions.microsoft.com> wrote in
> >> message
> >> >news:08f701c3c4a9$89412190$a501280a@.phx.gbl...
> >> >> I've set up a database maintenance plan in Enterprise
> >> >> manager, but it seems none of the jobs are running.
> What
> >> >> am I missing?
> >> >>
> >> >> Thanks
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >