Post reply

sql server 2012 scheduled jobs won't start

  • June 16, 2013 at 12:57 pm

    #273985

    Hello,

    I have done a big migration from Sql2008 to Sql2012 and besides a few Oracle related problems I have run into strange behavior with scheduled JOBs - they won't run...:)

    I have created the jobs by migrating the create scripts from Sql 2008 server and by just replacing the server names and the users that own the JOBs.

    I can run the JOBs fine manually but nothing happens when scheduled...?

    I have even added the accounts running both Sql Server and Sql Agent services to local Admin group

    Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64)

    Dec 28 2012 20:23:12

    Copyright (c) Microsoft Corporation

    Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

    Can you help?

    Ville

  • June 16, 2013 at 5:34 pm

    #1624456

    1) do the schedules actually exist?

    2) are the schedules enabled/associated with each job?

    3) do you get any errors in the sql agent error log?

    4) have you tried creating your own new schedule for a job and see if that works?

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • June 16, 2013 at 11:09 pm

    #1624467

    Hello,

    OK, even though the GUI shows 'x' Enabled the create script has like below...

    EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'LiDW_ETL_Paivittain_2045',

    @enabled=0,

    @freq_type=4,

    @freq_interval=1,

    @freq_subday_type=1,

    @freq_subday_interval=0,

    @freq_relative_interval=0,

    @freq_recurrence_factor=0,

    @active_start_date=20091106,

    @active_end_date=99991231,

    @active_start_time=204500,

    @active_end_time=235959,

    @schedule_uid=N'4cf46d10-932a-4a8b-8194-a7e6827ce4c6'

    I disabled from GUI - save - and Enable again - save but no effect...

    OK, I took all JOBs drop/create scripts and replaced @enabled = 0 ==> @enabled = 1

    Now OK, thank you for opening my tired eyes

    V

  • June 17, 2013 at 8:36 am

    #1624621

    Glad I could help. Sometimes (often actually) it is the simplest of things that trip us up! 😎

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

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

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