Schedule Generate SQL scripts

[Guest_imported]

does anyone know how to run scheduled generation of SQL scripts, without going through the Enterprise Manager?  How about 3rd party products?

 

[juls]

I wrote several scripts that have to be scheduled to run on a daily basis.  I used the isql utility to run the script from the command line and used NT scheduler to execute a BAT file at a certain time each day.  The isql utility takes in many command line parameters to customize the output of your script.  NT scheduler is executed using the AT command (use AT ? in DOS to get help).

 

[Gussy]

Get the NT Server Resource Kit, in there you will find an executable called WINAT and installed, go into START click in RUN and Type WINAT and OK. this is better than the AT command is user Friendly.