Joburi ce contin ssis package

Configurare noua (How To)

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

Tip solutie

Permanent
Etichetare:

Voteaza

(4 din 9 persoane apreciaza acest articol)

Despre Autor

Leave A Comment?