SQLMAINT 6.5

[chris ooro]

I would like to run the following SQLMAINT command on my database every
14days:

At 2:00 AM, this command needs to kick off: SQLMAINT.EXE -D cabinet
-CkAl -CkCat -UpdSts -RebldIdx 100 -Rpt D:MSSQLLOGcab_maint.rpt

Question: How can I "kill" all users, then place the database in "dbo"
mode, run "SQLMAINT", and then release database access back to the
public - all in an automated process.

Any suggestions would be "GREATLY" appreciated.

Thanks,
Chris

[Craig]

To get the users, write a kill script (which will fail sometimes) or do a netstop and netstart of the mssql service. This will work all the time.

When you do the netstart, then set the databases to DBO mode or whatever then run your maint............


------------
chris ooro at 10/6/99 11:22:34 AM

I would like to run the following SQLMAINT command on my database every
14days:

At 2:00 AM, this command needs to kick off: SQLMAINT.EXE -D cabinet
-CkAl -CkCat -UpdSts -RebldIdx 100 -Rpt D:MSSQLLOGcab_maint.rpt

Question: How can I "kill" all users, then place the database in "dbo"
mode, run "SQLMAINT", and then release database access back to the
public - all in an automated process.

Any suggestions would be "GREATLY" appreciated.

Thanks,
Chris