Search results

Thank for your help, but managed to crack it. Also added Duration time Max, Min and avg ,substring(right(stuff(' ', 1, 1,'000000')+convert(VARCHAR(6),active_start_time), 6), 1, 2)+':' +substring(right(stuff(' ', 1, 1,'000000')+convert(VARCHAR(6),active_start_time), 6),3 ,2)+':'...

SELECT DISTINCT substring(SYSJOBS.name,1,100) AS [Job Name], SYSJOBSTEPS.step_name AS JobStep, SYSCATEGORIES.name AS category, SYSJOBS.description as JobDescription, SYSJOBS.date_created as CreateDate, 'Enabled'=case WHEN SYSSCHEDULES.enabled = 0 THEN 'DISABLED' WHEN SYSSCHEDULES.enabled = 1...

I have the following script, which lists a lot of information regarding my Agent jobs on a server: SELECT DISTINCT substring(SYSJOBS.name,1,100) AS [Job Name], SYSJOBSTEPS.step_name AS JobStep, SYSCATEGORIES.name AS category, SYSJOBS.description as JobDescription, SYSJOBS.date_created as...

:( Hi Guys New to SQL coding so can someone please help? I monitoring our replication and would like to take a row count of a table ‘table1’ and match it to the replication table on our tier 2 and 3 environment . SELECT COUNT(*)AS alais FROM [servername].DB.dbo.Table SELECT COUNT(*)AS alais FROM...