SQLMAINT.EXE -- Returns only the switches

[jbrajgor]

Hi,

I am trying to run the following:

SQLMAINT.EXE -USA -P -S abc -D db1 -CkDB -Rpt c:\log_backup.rpt -DelTxtRpt 1days

But it simply returns the

SQLMaint switches and doesn't run the actual -CkDB?

Do I need to register any DLL to make this work ?

Thanks in advance,

[rmiao]

Did you check .rpt file for details? If you just want to check db, you can run 'dbcc checkdb' instead.

[jbrajgor]

It doesn't even create the file.

I need to use SQL maint to configure transaction backup in a batch file, Which later I would tie in to AutoSys Scheduler for Alerts.

Please help!

[rmiao]

Then try create maintenance plan in enterprise manager.