Post reply

why sql jobs are still running even if I disabled the jobs

  • November 13, 2008 at 2:55 pm

    #154916

    Hi guys,

    can any one please tell why sql jobs are still running even if I disabled the jobs in sql server 2005? do I have disable the schedules as well?

    thanks

    Joseph

  • November 13, 2008 at 3:26 pm

    #898342

    Even disabled jobs can be run. You can do so manually by right clicking on the job and selecting start job, or using msdb.dbo.sp_start_job stored procedure.

  • November 13, 2008 at 3:49 pm

    #898349

    Which version and service pack of sql server are you running? I tested it on my standard Edition, SP2 and job didn't run once its disabled even though schedule was kept enabled.

    MJ

  • November 14, 2008 at 3:07 pm

    #898901

    its Enterprise edition SP2

  • November 16, 2008 at 4:00 am

    #899060

    How do you disable the jobs, through the SSMS UI or through script?

    If through script, you must use the msdb proc sp_update_job:

    EXEC msdb.dbo.sp_update_job @job_name = @jobName, @enabled = 0;

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]

  • November 16, 2008 at 9:24 am

    #899081

    If you have DTS or SSIS packages, they may be calling some of those jobs and they'll run when called whether they're disabled or not.

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

  • November 20, 2008 at 10:21 am

    #901180

    thanks all....anyway now jobs are not running.

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

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