March 5, 2010 at 11:19 am
Hi everyone!
I've been working on a vb.net application. There is a section in our application that displays the current next run time. We allow the users to change the time it runs.
When the time is set, sp_update_jobschedule runs with the requested time. This portion seems to run correctly.
We know this because checking the job properties by right clicking and selecting properties in the Microsoft SQL Server Management Studio we see the correct time the user set it at.
However in the vb.net app we basically run a select off of next_run_time.sysjobschedules. For whatever reason the correct time the user had just set is not displayed. I am guessing the time will correct itself once the job actually runs again.
Here are my questions:
1) Is there any way to force the 'next_run_time' to show the correct time it will run again without running the job first?
2) is there a better way to display the real 'next_run_time'?
3) What is the best way to show a user when the next run time is going to be?
I hope someone out there can answer these questions! Thanks in advance.
March 6, 2010 at 9:06 am
Are you re-running your select of next_run_time in the VB.NET app after you set the time.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
March 6, 2010 at 10:18 am
Yes, and I select through SQL Management Studio to double check as well.
Though when I check through the SQL Management Studio GUI it shows the correct next run time. I need to capture it when the application.
Any help or suggestions would be appreciated.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply