Forum Replies Created

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

  • RE: convert from MM/DD/YYYY to YYYYMMDD

    SELECT j.[name],

    s.step_name,

    h.step_id,

    h.step_name,

    h.run_date,

    h.run_time,

    h.sql_severity,

    h.message,

    h.server

    --yyymmdd -20120128

    ,CAST(h.run_date as int ) date_convert, convert(char(10),DATEADD(d, -7, GETDATE()),112) TARGET,h.run_status

    FROM msdb.dbo.sysjobhistory h

    INNER JOIN msdb.dbo.sysjobs j

    ON h.job_id = j.job_id

    INNER JOIN msdb.dbo.sysjobsteps s

    ON j.job_id = s.job_id

    AND...

    February 23, 2012 at 5:03 am

    #1450766

  • RE: convert from MM/DD/YYYY to YYYYMMDD

    SELECT j.[name],

    s.step_name,

    h.step_id,

    h.step_name,

    h.run_date,

    h.run_time,

    h.sql_severity,

    h.message,

    h.server

    --yyymmdd -20120128

    ,CAST(h.run_date as int ) date_convert, convert(char(10),DATEADD(d, -7, GETDATE()),112) TARGET,h.run_status

    FROM msdb.dbo.sysjobhistory h

    INNER JOIN msdb.dbo.sysjobs j

    ON h.job_id = j.job_id

    INNER JOIN msdb.dbo.sysjobsteps s

    ON j.job_id = s.job_id

    AND...

    February 23, 2012 at 5:02 am

    #1450765

  • RE: Date Format (mm/dd/yyyy hh:mm), no seconds or milliseconds

    For the format : -- MM/DD/YYYY HH:MMAM/PM

    CONVERT(VARCHAR(10), GETDATE(), 101) + ' ' + RIGHT(CONVERT(VARCHAR, GETDATE(), 100), 7)

    December 16, 2009 at 3:01 am

    #1092883

  • RE: Logging Perfmon Counters to SQL 2005

    Great that works! - Givign permission on the C:\PerfLogs folder...

    September 15, 2009 at 7:18 am

    #1053747

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