Job Scheduling

Question

Viewing 3 posts - 1 through 4 (of 4 total)

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

MohammedU SSCoach Points: 19644 More actions · Answer 1

Some other job or process or person may be diabling the job...

But any way check job end date in schedule table...if this is wrong this should disable the schedule but not the job.

Note: Run the SQL trace with the JobName filter in it to see what is causing this issue.

MohammedU
Microsoft SQL Server MVP

devaraya Default port Points: 1455 More actions · Answer 2

Hi Uddin,

Thank You very much for your response.

I set it as no end date and i have two jobs running on same intervels. Is this wrong?

Ramaa

devaraya Default port Points: 1455 More actions · Answer 3

Hi Uddin,

I solved out the problem.I changed the job schedule daily now it is working.Thank you for your response.

Ramaa