SQL server jobs

Question

Post reply

SQL server jobs

D Dave

SSC Enthusiast

Points: 139
More actions
March 19, 2010 at 12:13 am

#156798

Hi,
I have a few jobs scheduled to run at particular times during the day on sql server 2005. Few days back, the system date of the server was changed and after a couple of days, corrected to the actual one. Since then the jobs are not running automatically at the scheduled times.
Please help me with the above problem.
Thanks in advance...

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

run

select GETDATE() and confirm you're SQL server returns the exact same date and time as you're Windows Server.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

D Dave SSC Enthusiast Points: 139 More actions · Answer 2

Hi,

Thanks for the immediate response...

Yes... the query returns the same date as the system date...

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 3

create a new simple job with a quick t-sql query, schedule it for 5 minutes ahead of now, check if it runs at the exact time.

If it does, I'd say, reconfigure you're schedule's, and apply.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

D Dave SSC Enthusiast Points: 139 More actions · Answer 4

Hi,

I deleted one of the jobs and recreated it...

It successfully executed on schedule...

So I think I'll have to reconfigure the existing jobs...

The main issue is the Replication which is configured...

If I recreate the jobs meant for replication, will it be affected??

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 5

If I recreate the jobs meant for replication, will it be affected??

Yes, but DONT recreate the jobs, simply modify the existing schedules, by changing the time, and changing it back (to the original, and correct times) and applying.

I suspect the schedules might be a bit confused.... 😉

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

D Dave SSC Enthusiast Points: 139 More actions · Answer 6

Yeah Thanks,

The Issue is solved now... I think the Server needed as Restart for refreshing the cache...

The jobs are running on schedule now...

Thanks for all the help... 🙂

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 7

Np, pleasure.

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle