Situatie
Mai jos este o procedura ce ruleaza pe baza msdb a unui server de sql. Aceasta returneaza o lista cu joburile ce contin SSIS Packages, precum si locatia acestor packages.
Solutie
create procedure JoburiCuSsis_prc
as
SELECT
sysjobs.name AS ‘JobName’,
sysjobsteps.step_id AS ‘StepNumber’,
sysjobsteps.command AS ‘SSISLocation’
FROM sysjobs
JOIN sysjobsteps ON sysjobs.job_id = sysjobsteps.job_id
where subsystem=’ssis’
order by 1
Leave A Comment?