Post reply

How to debug jobs?

  • April 18, 2011 at 7:02 am

    #249179

    :hehe:How to debug jobs?

    I have one typical problem,In one of our site the DNS has changed from Linux to Windows...from then the Jobs are running successfully but jobs are not doing there actual work... why manually it is working.

    Thanks

  • April 18, 2011 at 7:10 am

    #1312727

    Have a look on the following links to have some idea

    Monitoring Job Activity

    http://msdn.microsoft.com/en-us/library/ms188272.aspx

    Job Activity Monitor

    http://msdn.microsoft.com/en-us/library/ms178510.aspx

    Thanks
    Parthi

  • April 19, 2011 at 3:11 am

    #1313219

    Please find the error:

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, Cannot generate SSPI context [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [382] Logon to server '(local)' failed (JobManager)

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, SQL Network Interfaces: The target principal name is incorrect. [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, Cannot generate SSPI context [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [382] Logon to server '(local)' failed (ConnUpdateJobActivity_NextScheduledRunDate)

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, SQL Network Interfaces: The target principal name is incorrect. [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, Cannot generate SSPI context [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp)

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, SQL Network Interfaces: The target principal name is incorrect. [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [298] SQLServer Error: 802, Cannot generate SSPI context [SQLSTATE HY000]

    2011-04-19 08:59:10 - ! [382] Logon to server '(local)' failed (ConnAttemptCachableOp)

    2011-04-19 09:18:14 - ! [298] SQLServer Error: 802, SQL Network Interfaces: The target principal name is incorrect. [SQLSTATE HY000]

    2011-04-19 09:18:14 - ! [298] SQLServer Error: 802, Cannot generate SSPI context [SQLSTATE HY000]

    2011-04-19 09:18:14 - ! [382] Logon to server '(local)' failed (SaveAllSchedules)

    Thanks

  • April 19, 2011 at 6:29 am

    #1313284

    check the SQL Server agent service account it is working or not if you are using domain account for this service

    is SQL Server machine name is changed after DNS changed ?

    If change the replace the new one as

    SELECT @@SERVERNAME

    sp_dropserver 'Server Name'

    go

    sp_addserver 'Server Name',local

    go

    this should be same as machine name then restart the SQL Server service

    Regards,

    Syed Jahanzaib Bin Hassan

    MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog

    http://www.aureus-salah.com

    Regards,
    Syed Jahanzaib Bin Hassan
    BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA

    My Blog
    www.aureus-salah.com

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

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