var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Hi I have a problem with sp_help_jobschedule.
I have a job which is executed very often : every 10 minutes. I check if the job has succeded and with sp_help_jobschedule, i get the next run date. The problem is that this date seems to be updated every 30 minutes. How can i make it updated every 5 minutes ?
Are you sure that the job is completing in under 10 minutes? If not (say it completes in 21 minutes), then it will schedule itself to run at the next 10 minute interval.
Check your job history (go into Enterprise Manager, drill down on Management/SQL Agent/Jobs, Right-click on the job in question and select Job history. Check to see how long it's actually taking.
You might want to check out SQL Agent Mail, too. It can give you hands-off monitoring of job performance.
The job is completed in 11 or 12 minutes so less than 20 minutes.
It is a fast backup. It stores very important datas.
The schedule will be updated once the job completes, so in your case it should be once in every 12 mins. or so.
The schedule is updated. That is not the problem.
I would like to get the time and date of the next run but with 'sp_help_jobschedule' the date and the time are updated every 20 minutes.
If its updating every 20 mins then it seems job is taking the same time to finish, to monitor the event take help of PROFILER and see what sort of activity is taking place.
I have a Sql job which is executed every ten minutes. The execution takes less than one minute. I want to get the time of the next execution with sp_help_jobschedule but this time is not updated after the execution of the job. It is updated every 20 minutes not every 5 or 6 minutes.
i have the same problem, the best solution i've found until now is use the SQLDMO objects
Dim srv As new SQLDMO.SQLServer2
Dim qd As SQLDMO.QueryResults2
Dim jname As String
Dim i As Long
Dim NextRunDate As Long
Dim NextRunTime As Long
'login the server
srv.LoginSecure = True
Set qd = srv.JobServer.EnumJobs
For i = 1 To qd.Rows
jname = qd.GetColumnString(i, 3) 'job name
If UCase(jname) = UCase(<your job name>) Then
NextRunDate = qd.GetColumnLong(i, 23)
NextRunTime = qd.GetColumnLong(i, 24)