Scheduling a .sql script file ?????

[jballum]

What is the best way to schedule a .sql script file keeping in mind that the contents of this file could change daily?

JB

 

[foxdev]

You could schedule ISQL with your .SQL file as the argument to the -I option. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[jballum]

Thanx for your prompt response.

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).

Any ideas?

JB

 

[foxdev]

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

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org

 

[jballum]

That is what I thought. I was hoping to use SQL so that I could sync the existing jobs easier.

Thanx again.

JB

 

[foxdev]

You can use SQL Server Agent to create a job where the step is an operating system command, so that would be an alternative. Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org