Post reply

SQL2000 job step

  • April 19, 2011 at 7:25 pm

    #142469

    Hi, i need to know where I can get the command in job aside from sysjobsteps. I'm using sql2000.. When I query the job in sysjobsteps, the command column is incomplete.

    Thanks in advance.

  • April 19, 2011 at 7:47 pm

    #1313713

    Hi,

    If the column is incomplete it is probably related to your SSMS settings. Go into "Tools\Options" select "QueryResults\SQLServer\ResultsToGrid" and check the maximum number of characters retrieve. Change the setting to the appropriate value and bingo, you can now see all of the data.

  • April 19, 2011 at 7:56 pm

    #1313715

    thanks. But I need to just query it.. The column command has a length of 3200. And the command in job is more than 3200 characters.

  • April 19, 2011 at 8:01 pm

    #1313716

    Then there has to be another row in the table to contain the rest of it. syscomments works exactly like that with the text column and colid (rowid).

  • April 19, 2011 at 8:47 pm

    #1313721

    Thanks.. I got it..

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

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