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 |
|
kris22
Starting Member
35 Posts |
 Posted - 2009-03-24 : 18:49:34
|
| Hi Guys, I have a date field in one of my sql table. i have to keep track of that field and if there is no change in the date with in 2 days then i need to call another function to perform the validation. How can we do this? i am using Vb.Net/Asp.net and VS.Net2003. appreciate your helpthanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-25 : 11:07:38
|
| Depending on how accurately you want to chase the 2 days time frame you can create a job that wakes up probably every hour and checks for the date..and alerts you/call the function when necessary.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
kris22
Starting Member
35 Posts |
Posted - 2009-03-25 : 14:41:05
|
quote:
Originally posted by dinakar
Depending on how accurately you want to chase the 2 days time frame you can create a job that wakes up probably every hour and checks for the date..and alerts you/call the function when necessary.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
Do you think we can create a job to call the VB.NET function from sql? if so can you explain me more?Thanks |
|
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-25 : 14:50:32
|
| couldnt you move the logic from the .net function to a stored proc?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
|
|
|
kris22
Starting Member
35 Posts |
Posted - 2009-03-25 : 15:13:47
|
quote:
Originally posted by dinakar
couldnt you move the logic from the .net function to a stored proc?Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/
I think i can move to storedprocthanks for the info |
|
|
|
|
|
|
Tracking Date field in sql table