none
SQL Agent Restart time

All replies

  • Not sure about Query but errorlog will surely tell you

    sp_readerrorlog


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, August 12, 2013 3:15 AM
  • I have used xp_cmdshell to read the SQLAGENT.OUT ,confirmed SQL agent is started  however find an error:

    已拒絕執行作業 DB_MAINPLAN (來自 使用者 sa),因為該作業目前未執行

    Anybody experienced SQL Agent Job missed the schedule???

    Monday, August 12, 2013 4:40 AM
  • create one job to store last agent restart time > create job to put current date into that table > schedule job to run when agent start. your can also set an email alert to send at agent start.

    Regards,
    Rohit Garg
    (My Blog)
    This posting is provided with no warranties and confers no rights.
    Please remember to click Mark as Answer and Vote as Helpful on posts that help you. This can be beneficial to other community members reading the thread.

    Monday, August 12, 2013 5:16 AM
  • Thanks, so means you think SQL agent was not starting properly ?

    anyone experienced SQL Agent Job missed the schedule???

    Monday, August 12, 2013 8:06 AM
  • anybody can help ? I am afraid this happen to other sql server as well...
    Monday, August 12, 2013 4:19 PM
  • anybody can help ? I am afraid this happen to other sql server as well...

    Hello,

    Please open new thread for this question ,we will try to answer it. Please give all details.Did you checked the timing was it perfect?

    Any logs for SQL server agent you can provide ,Job completion history


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Monday, August 12, 2013 4:28 PM
  • timing is perfect..

    as some jobs runs on time, some jobs didn't ... very strange.

    Tuesday, August 13, 2013 1:54 PM
  • you can read from SQL Server agent log

    sp_readerrorlog -1, 2 -> Reads the current SQL Agent errorlog

    More details in http://mssqlwiki.com/2011/02/13/beyond-xp_readerrorlog/


    Thank you,

    Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Friday, August 16, 2013 5:30 AM
  • SQL agent error log also normal......

    it's very very stange situation.. I still couldn't find the root causes.

    Friday, August 16, 2013 7:38 AM
  • SQL agent error log also normal......

    it's very very stange situation.. I still couldn't find the root causes.

    What is the issue? You want to find when SQL Server agent is restarted (or) why the job did not run?  How are you checking if the job run?


    Thank you,

    Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Friday, August 16, 2013 8:00 AM
  • I want to check why the job did not run.

    even the sql agent started up already.

    Friday, August 16, 2013 9:28 AM
  • I want to check why the job did not run.

    even the sql agent started up already.


    Can you share @active_start_time and @active_end_time of job?

    Thank you,

    Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Friday, August 16, 2013 11:15 AM
  • the job start 3 times during a day at 3 time using 3 schedule in the job.

    there is no end date.

    Monday, August 19, 2013 3:49 AM
  • the job start 3 times during a day at 3 time using 3 schedule in the job.

    there is no end date.


    Right click and Script the job. Under the schedule you will find @active_start_time and @active_end_time

    Thank you,

    Karthick P.K |My blogs|My Scribbles|Twitter|My Facebook Group|

    www.Mssqlwiki.com

    Please click the Mark as answer button and vote as helpful if this reply solves your problem

    Monday, August 19, 2013 6:04 AM
  •   @active_start_time=124500,
      @active_end_time=235959
      @active_start_time=164500,
      @active_end_time=235959
      @active_start_time=94500,
      @active_end_time=235959
    Monday, August 19, 2013 6:20 AM