Patrick,
There is just the one step and they are only running for 1 second before
they fail.
Elecia


-----Original Message-----
From: Patrick Gallucci [mailto:[Email Address Removed] Wednesday, January 29, 2003 8:11 PM
To: 'Elecia Ezell'; 'LazyDBA.com Discussion'
Subject: RE: Maintenance jobs are failing


Elecia,

That does not mean the whole job failed.

Do this...

Navigate to and then expand Database Maintenance Plans.
Right-click the Database Maintenance Plan for which the corresponding
job failed.
Click Database Maintenance Plan History.

Show steps and see what exact step failed...should give you more
information as well...If still unresolved reply and will dig deeper...

Patrick Gallucci
http://www.patrickgallucci.com
[Email Address Removed] 214-642-0524

Dallas Web Builder, Inc.
http://www.dallaswebbuilder.com
15950 North Dallas Parkway
Tower Two, Suite 400
Dallas, Texas 75248

office: 972-361-8017
fax: 972-361-8005

-----Original Message-----
From: Elecia Ezell [mailto:[Email Address Removed] Wednesday, January 29, 2003 7:11 PM
To: LazyDBA.com Discussion
Subject: Maintenance jobs are failing


Hi all,
I am trying to execute my maintenance jobs that I created using the sql
wizard but they fail each time. When I view the job history this is the
error given.

Executed as user: NT AUTHORITY\SYSTEM. sqlmaint.exe failed. [SQLSTATE
42000] (Error 22029). The step failed.

I looked at the permissions on the extended stored procedure sqlmaint
and public user has exec permission. I am clueless as to what the
problem is. Any assistance would be greatly appreciated.

Thanks in advance,
Elecia

MS Sql Server LazyDBA home page