I was looking for suggestions on what to use to schedule it. Up till now I have set up a bunch of scheduled jobs that run different TSQL scripts using the SQL Server Agent. Scheduling to run an actual script file cannot be done using the agent (at least not that I have found).
You didn't mention what operating system you are using, but you can schedule a task (ISQL.EXE with the apppropriate arguments) using NT4 or Win2K. In other words, use the OS to schedule the tasks, not SQL Server. Robert Bradley
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.