Posted by Stephen2 on 07/20/07 12:14

I've written a small dos batch script that runs a simple query through
osql and then calls an exe which sends an email if the returned value
> 0.

The query checks if a value in a column has not been updated for 5
mins and raises a warning through an email and it will need to run
throughout the online day.

Will there be any issues continually opening & closing connections in
this way?

Would there be any advantage in scheduling it as a job in Windows v a
scheduled job in SQL Server to run every 5 mins?

Thanks.

[Back to original message]