March 14, 2012 at 12:08 pm
Hello All,
I want to make a 'routine' which will be running in a database of SQL server every day on 08:00 am/pm. The routine's task is to check two table's date-columns: start date and end date, and when the current date is out of that range, another column-bit as status will be set to active/inactive.
I know i can realize this with triggers or through an application, but i don't want the triggers to run frequently or use application... How can i resolve this task with just one-short automatic run per day.
I'll be thankfully for some good advises ...
Kind regards
Igor Micev
Igor Micev,My blog: www.igormicev.com
March 14, 2012 at 12:13 pm
I would create a stored procedure and then create a job to run it on a schedule with SQL Server Agent.
Jared
CE - Microsoft
March 14, 2012 at 2:05 pm
Thank you Jared
I tried and succeed. I admit that my administration skills are not as good as my developing. However I'm working on it.
Actually, I can now conclude that the job-strategies are similar(even same) at almost all systems. I've been working on a system with NoSQL database, and there I used to create jobs.
Thanks again
-Igor Micev
Igor Micev,My blog: www.igormicev.com
March 14, 2012 at 2:12 pm
IgorMi (3/14/2012)
Thank you JaredI tried and succeed. I admit that my administration skills are not as good as my developing. However I'm working on it.
Actually, I can now conclude that the job-strategies are similar(even same) at almost all systems. I've been working on a system with NoSQL database, and there I used to create jobs.
Thanks again
-Igor Micev
Ugh... NoSQL... 🙂 I prefer structured data.
Jared
CE - Microsoft
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply