Search results

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...