I have done a lot with sql and jobs, and this is throwing me off.
My job is scheduled as shown below.
I can run the job interactively from SSMS by starting the job, it runs, all is well.
It is currently Jan 27 at 11 AM local time. But sp_help_jobactivity returns a next_scheduled_run_date of
next_scheduled_run_date 2012-01-27 12:01:00.000
I expect it to be four hours from the last time I ran it, or from when I created the job and schedule (which I created at the same time).
Observed Problem: While the SSMS GUI displays "12:01 AM" the data in next run shows "12:01:00" which is "12:01 PM"
What am I missing? When will the job next run?