next run date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ronnie - 10 Mar 2008 21:01 GMT

I am setting up a new job that will run weekly. However, after setting up the
job the "NEXT RUN DATE" does not display. If I set up this job on another
server this date does get displayed. What might be the reason for this
behavior?

Reply to this Message

Anith Sen - 10 Mar 2008 21:17 GMT

Can you post the results of the following query here:

SELECT * FROM msdb..sysjobschedules s1
WHERE EXISTS ( SELECT * FROM msdb..sysjobs s2
WHERE s2.job_id = s1.job_id )
AND s2.name = <jobname> );

Replace <jobname> with the name of your job.

Signature

Anith

Reply to this Message

ronnie - 10 Mar 2008 21:43 GMT

Hi,

Below are the results:

schedule_id job_id    name
enabled
-----------    ------------------------------------
-----    -----------
37    DE69831F-F6EA-4E71-89B3-6542F82A8D2F test    1

freq_type    freq_interval    freq_subday_type    freq_subday_interval
-----------    -------------    ----------------    --------------------
8    4    1    0

freq_relative_interval    freq_recurrence_factor
active_start_date    active_end_date
----------------------    ----------------------
-----------------    ---------------
0    1    20080310    99991231

active_start_time    active_end_time    next_run_date    next_run_time
-----------------    ---------------    -------------    -------------
100000    235959    0    0

date_created
-----------------------
03/10/2008 15:27:27.27

> Can you post the results of the following query here:
>
[quoted text clipped - 4 lines]
>
> Replace <jobname> with the name of your job.

Reply to this Message

ronnie - 11 Mar 2008 13:46 GMT

I see that the next_run_date and next_run_time is not getting inserted into
the sysjobschedules table in msdb database after I create the job. What might
be the reason that this is not getting inserted? This works correctly on
other servers. Is this a permissions issue?

Thanks in advance.

> Hi,
>
[quoted text clipped - 32 lines]
> >
> > Replace <jobname> with the name of your job.

Reply to this Message