Tag: sql server agent
Comment afficher la liste des clés primaires et des clés étrangères...
SELECT DISTINCT
Constraint_Name AS ,
Table_Schema AS ,
Table_Name AS
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
GO
Comment connaitre les jobs en cours d’exécution ?
SELECT ., ., ., .
FROM .. sjv
JOIN .. sja
ON . = .
WHERE . is not null
AND . is null