Post reply

Job Scheduled - Doesnt Kick off - Strange

  • December 21, 2009 at 6:50 pm

    #136143

    This forum has helped me solving so many issues, i am back with another strange issue and i request suggestions..i have a job which is scheduled....the job didnt run at all..this is on a cluster..i looked the sql error log nothing is there..i looked the default trace cldnt find anything...there isnt anything in cluster log too...my guess is right when the job was about to kick off it cld have failed over to the other node and got stuck....unfortunately we didnt realize this until 10 days...please help..thanks

  • December 21, 2009 at 8:22 pm

    #1095222

    Is the job disabled? Disabled jobs would not run at the schedule time.

    Bru Medishetty

    Blog -- LearnSQLWithBru

    Join on Facebook Page Facebook.comLearnSQLWithBru

    Twitter -- BruMedishetty

  • December 21, 2009 at 11:38 pm

    #1095253

    Just go to the job properties and make sure that it is enabled.

  • December 22, 2009 at 7:05 am

    #1095379

    Just check sql error logs and make sure that neither agent service nor sql service restarted at job's scheduled time...

    MJ

  • December 22, 2009 at 8:51 am

    #1095440

    thanks everyone..yes the job was enabled...there are other jobs on the same instance and they ran fine with no issues..only just this one..

  • December 23, 2009 at 2:14 pm

    #1096136

    Even though you say it's scheduled make sure the schedule is enabled too.

  • December 24, 2009 at 1:44 am

    #1096253

    iqtedar (12/21/2009)

    This forum has helped me solving so many issues, i am back with another strange issue and i request suggestions..i have a job which is scheduled....the job didnt run at all..this is on a cluster..i looked the sql error log nothing is there..i looked the default trace cldnt find anything...there isnt anything in cluster log too...my guess is right when the job was about to kick off it cld have failed over to the other node and got stuck....unfortunately we didnt realize this until 10 days...please help..thanks

    Hi,

    Run the following query and check status

    select sj.name,sj.enabled,sj.date_modified,next_run_date,ss.next_run_time,

    sh.run_date,sh.step_id,sh.message,sh.run_status

    from msdb.dbo.sysjobschedules ss

    join msdb.dbo.sysjobs sj

    on(ss.job_id=sj.job_id)

    join msdb.dbo.sysjobhistory sh

    on(sh.job_id=sj.job_id)

    where sj.name='@jobname'

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

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

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