This is for a test server running SQL Server 2008.
We have a task scheduled through SQL Server Agent that's supposed to run every few minutes. Apparently, somebody a few months ago did a test where they changed the server date to the future, then changed it back. So we have record of things running on August 30, 2015, even though that's not until next week.
We cleared out the log history and data that we know of with the future dates, but for some reason, our scheduled job claims that it's not scheduled to run again until August 30, even though I just ran it manually, and its schedule in its properties says it should be running every few minutes. Any idea what I'm missing that would cause it to retain that August 30 scheduled date and ignore its "every few minutes" scheduling?