batch file

I have a batch file I use to backup every night, is there a command I could use to restart the computer? I'd like to automate it as well. Thanks, Craig

Reply to
Craig
Loading thread data ...

if u r using windows xp, u can use the shutdown.exe command located in system32 directory, for windows 2000, u might try rundll32, i don't remember the exact syntax but i can get it for u if you OS doesn't have the shutdown.exe

Nashat

Reply to
Nashat

Reply to
Craig

just use shutdown -r u can go to the command prompt and type shutdown /? for different options

Reply to
Nashat

Reply to
Craig

Reply to
Craig

Reply to
Craig

Do u use full SQL server or MSDE?

Reply to
Nashat

the attached file will create a job for u to reindex MyDB database once a week with a fillfactor of 90 u can run this script in Administrator

begin 666 Reindex job.sql M__XM`"T`( !3`&,`

Reply to
Nashat

MSDE

Reply to
Craig

Reply to
Craig

Craig,

The .sql file he wrote is a job. Once you run the .sql file on the msde server it will create a job to run at the interval specified in the schedule section of the .sql file.

You may want to go to microsoft.com and search for osql.exe, msde job, sql job, job step, etc.. to get information on exactly what jobs are and how to write them to automate sql server (or msde) db maintenance tasks. You will be glad you did.

Logon your CPU as administrator, start the SO Administrator program, connect to the database, open his attached .sql file and play it (run it). It will create the job for you. The job will run by itself at specified intervals.

Reply to
root

Reply to
Craig

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.