|
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.
Navigation:
[Reply to this message]
|