helo all. I'm trying to automate database maintanence for RealSecure 6.5's ISSED. I've tried the recently mentioned dbms application, but its a little too buggy (v 0.1) for a production environment. What I'd like to create is a simple script that will do the following:
* backup database issed to issed%date%.bak * exec iss_truncateevents * wzzip issed-%date%.zip issed%date%.bak * scp issed-%date%.zip <user@fileserver:/path> if I can then use the windoze scheduler to execute this .bat file on the event collector, then I can walk away and never touch the box again :^D the best I've been able to do so far is wade through the wizards and get MSSQL running the backup and purge, then having the scheduler come along afterwards and rename the backup file, zip it and scp it. Which is a bit ha-ck-ish. Big problem is I don't know how to send arguments to OSQL inside of a script. P.S Does anyone know of a good unix command line emulator for windoze? I keep typing ls instead of dir, mv instead of ren, etc... P.P.S. I've been truncating ISSED without stopping the Event collector with no problems (so far). Am I eventually going to break something? I'm running the full MSSQL server backend and it seems to handle matters well...
