Welcome to Sign in | Help

Re: Eroare vizualizare proprietate job in SQL management studio

  •  03-07-2009, 8:03 AM

    Re: Eroare vizualizare proprietate job in SQL management studio

    Încearcă te rog următorul query şi spune-ne rezultatele:

    declare @tmp_sp_help_jobhistory table
    (
    instance_id int null,
    job_id uniqueidentifier null,
    job_name sysname null,
    step_id int null,
    step_name sysname null,
    sql_message_id int null,
    sql_severity int null,
    message nvarchar(4000) null,
    run_status int null,
    run_date int null,
    run_time int null,
    run_duration int null,
    operator_emailed sysname null,
    operator_netsent sysname null,
    operator_paged sysname null,
    retries_attempted int null,
    server sysname null
    )

    insert into @tmp_sp_help_jobhistory
    exec msdb.dbo.sp_help_jobhistory
    @mode='FULL'

    SELECT * FROM @tmp_sp_help_jobhistory WHERE message LIKE '%'+CHAR(0x1F)+'%'

    Răzvan
View Complete Thread
Powered by Community Server (Commercial Edition), by Telligent Systems