What is the step? A backup? Tran log backup? Is this against master?
-----Original Message-----
From: Elecia Ezell [mailto:[Email Address Removed]
Sent: Wednesday, January 29, 2003 7:22 PM
To: LazyDBA.com Discussion
Subject: RE: Maintenance jobs are failing
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
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page