next run date

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?
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.
Anith
|||Hi,
Below are the results:
schedule_id job_id name
enabled
-- --
37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
freq_typefreq_intervalfreq_subday_typefreq_subday_interval
8 4 1 0
freq_relative_intervalfreq_recurrence_factor
active_start_dateactive_end_date
0 1 2008031099991231
active_start_timeactive_end_timenext_run_datenext_run_time
100000 235959 0 0
date_created
03/10/2008 15:27:27.27
"Anith Sen" wrote:

> 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.
> --
> Anith
>
>
|||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.
"ronnie" wrote:
[vbcol=seagreen]
> Hi,
> Below are the results:
> schedule_id job_id name
> enabled
> -- --
> --
> 37 DE69831F-F6EA-4E71-89B3-6542F82A8D2F test1
> freq_typefreq_intervalfreq_subday_typefreq_subday_interval
> ----
> 8 4 1 0
> freq_relative_intervalfreq_recurrence_factor
> active_start_dateactive_end_date
> --
> 0 1 2008031099991231
>
> active_start_timeactive_end_timenext_run_datenext_run_time
> ----
> 100000 235959 0 0
>
> date_created
> --
> 03/10/2008 15:27:27.27
>
>
>
>
>
> "Anith Sen" wrote: