Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
 Posted - 2001-12-06 : 13:18:02
|
| Database maintenance plan failed.error is:sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.What am i doing wrong?Any help is appreciated.Rita |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-06 : 13:32:11
|
| Using maint.exe.You can set the plan to log and look at the log.Safer to not use a plan but to code the tasks yourself. It is easy to do, you have more control, are confident about what it is doing and don't have to run an external exe that controls things.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
 |
|
|
Rita Bhatnagar
Posting Yak Master
172 Posts |
Posted - 2001-12-06 : 14:02:49
|
| I don't have confidence in creating task.Would you direct me where to look for help creating different kinds of tasks.Thanks.Rita |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2001-12-07 : 06:18:06
|
| You create tasks in enterprise manager.got to management, sql server agent, jobsright click new job.give the job a name, add a job step - set the name, database, command as 'exec sp...'add a schedulemake sure the job and schedule are enabled and it will run at the scheduled times.For the commands to put in the SP look in bol.you will want a 'backup database' or several.you may want some dbcc commands to check/reindex the database too if it is not a 24 hour system.==========================================Cursors are useful if you don't know sql.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Database maintenance Plan