Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
arunv
Starting Member
3 Posts |
 Posted - 2010-08-08 : 22:44:03
|
| Hi, Some one please advice a better solution I have few rows under a category and 5 hours to send messages from selected rows.when a category has 25 - every 12 mins the program should be called that is 5 messages per hourwhen there are 5 - every 1 hour the program should be called.when there are 10 - every 30 mins the program should be called and so on.... as the number is dynamic, the firing of program should be dynamic, which is a lil tricky thing ., working on figuring out a way for dynamic calling of program because if we make it occur every 12 mins - even there are 5 messages - it will send all 5 in a single hour - every 12 mins if we make it occur every 30 mins - then 25 messages cannot be finished in single 5 hour span.. |
|
|
Liam
Starting Member
6 Posts |
Posted - 2010-08-12 : 14:48:19
|
| I don't fully understand your post but it seems you should call your messaging function frequently i.e. always every 12 mins. write into the messaging function to skip some sends depending on the volume of messages to send. |
 |
|
|
|
|
|
SQL Job Agent help please