Post reply

Sql job

  • June 24, 2011 at 12:48 pm

    #242856

    Hello,everyone

    I had a Sql job which is hung and later running for more than the time expected and their is custom error ( Error: 50000 Severity: 16 State: 1).So can anyone help me in how to fix this issue or can any one guide me to the right path in this issue.

    thanks,in advance

  • June 27, 2011 at 7:48 am

    #1344518

    Check the sysmessages table. For instance:

    Run this syntax and send a result(more info)

    SELECT *

    FROM

    sysmessages

    WHERE error = 50000

  • June 28, 2011 at 2:50 am

    #1345015

    mnagasrikanth219 (6/24/2011)

    Hello,everyone

    I had a Sql job which is hung and later running for more than the time expected and their is custom error ( Error: 50000 Severity: 16 State: 1).So can anyone help me in how to fix this issue or can any one guide me to the right path in this issue.

    thanks,in advance

    Need more info. post me a full error.

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

  • June 28, 2011 at 5:16 am

    #1345080

    Execute the job and check the locks on the tables which those are using in this job and check the status of this job with the help of this query

    SELECT ST.TEXT,SP.SPID,WAITTIME,LASTWAITTYPE,CPU,PHYSICAL_IO,STATUS,HOSTNAME,PROGRAM_NAME,CMD,LOGINAME FROM SYS.SYSPROCESSES SP

    CROSS APPLY SYS.DM_EXEC_SQL_TEXT(SP.SQL_HANDLE) ST

    WHERE STATUS !='SLEEPING'

    ORDER BY CPU DESC

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

    My Blog
    www.aureus-salah.com

  • June 28, 2011 at 5:28 am

    #1345088

    Run the following syntax and ckeck:

    SELECT *

    FROM

    sysmessages

    WHERE error = 50000

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

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