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
- posted
17 years ago
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
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
just use shutdown -r u can go to the command prompt and type shutdown /? for different options
Do u use full SQL server or MSDE?
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`&,`
MSDE
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.
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.