Post reply

Job Scheduling

  • December 1, 2006 at 11:17 pm

    #193297

    Greetings Everybody,

    I have a problem on Job scheduling in sql 2000. I wrote a procedure to kill the idle connections in the server and kill the idle connections through a job scheduler.Upto this it is ok. I set the job scheduling to kill idle connections for every 10 minutes.This is also working for the day but the next day i have to again check the enabled button to start the job. The server is up and running .No shutdown.What is the solution?

    Thanks in Advance

    Ramaa

  • December 1, 2006 at 11:33 pm

    #675330

    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

  • December 4, 2006 at 3:17 am

    #675402

    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

  • December 4, 2006 at 8:48 pm

    #675701

    Hi Uddin,

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

    Ramaa

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

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