141 reputation
6
bio website
location Canada
age 31
visits member for 2 years, 10 months
seen Aug 30 '12 at 19:21

i hear the buzz doesn't last that long.


Sep
24
awarded  Autobiographer
Aug
19
awarded  Popular Question
Aug
30
comment Why is the next scheduled run date for my SQL Server job NULL?
dba.stackexchange.com/questions/9925/…
Jul
17
awarded  Teacher
Feb
23
comment Why is the next scheduled run date for my SQL Server job NULL?
hey man thanks for the reply. i've seen that page as well and use the function that he's got outlined there. the fact of the matter is that the sysjobschedules & sysjobactivity tables don't agree as to when some jobs will fire which seems odd to me
Feb
23
comment Why is the next scheduled run date for my SQL Server job NULL?
right, sysjobschedules refreshes every 20 mins and won't necessarily have a value immediately, sysjobactivity is static, then? which one is correct? which one is actually telling me when the next job will fire?
Feb
23
revised Why is the next scheduled run date for my SQL Server job NULL?
added 433 characters in body
Feb
23
asked Why is the next scheduled run date for my SQL Server job NULL?
Feb
23
awarded  Scholar
Feb
23
accepted Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
Feb
23
revised Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
added 6 characters in body
Jan
4
answered Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
Jan
4
revised Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
edited title
Dec
30
comment Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
yeah, quite not sure about brian's comment there
Dec
30
comment Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
just double checked on a co workers machine by created a new test schedule/job with the same criteria and next scheduled run date is the 4th, which doesn't jive with what my scheduling calendar control is showing. hmmm.
Dec
30
comment Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
so my scheduler control that i'm using as the UI frontend for schedules/jobs stored against the sql DB's says that the next occurrence should happen on the 18th, but the next scheduled run date says the 4th.
Dec
30
comment Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
same values. i even went into the mgmt studio UI to create a job manually from there not using my UI, inputting the same criteria and I get the same date as a result: 20120104 154500. maybe that date is correct?
Dec
30
comment Why might Sql Server Agent's Next Run Time value not be what I expect? And is this definitely the next time my job will run?
tried that query and i get 2012-01-04 15:45:00.000 for the next run date...
Dec
30
awarded  Student
Dec
29
awarded  Editor