I hereby claim:
- I am cporteou on github.
- I am cporteous (https://keybase.io/cporteous) on keybase.
- I have a public key ASDwx4QcjXFczeW6YMYevDvUMVjV5iTPUQ8wSGsulC93hQo
To claim this, I am signing this object:
# CICD Pipeline for Azure Data Factory | |
# Author: Craig Porteous (@cporteous) | |
trigger: | |
- adf_publish | |
pool: | |
vmImage: 'vs2017-win2016' | |
stages: |
I hereby claim:
To claim this, I am signing this object:
#--------------------------------------------- | |
# Author: Craig Porteous | |
# @cporteous | |
# Synopsis: List out all SSRS (native mode) | |
# folders & their security policies | |
# & output dataset to CSV file | |
#--------------------------------------------- | |
Clear-Host | |
$ReportServerUri = 'http://REPORTSERVERURL/ReportServer/ReportService2010.asmx?wsdl' |
USE ReportServer | |
SELECT | |
cat.Name, | |
cat.Path, | |
sch.ScheduleID AS AgentJobID, | |
sch.LastRunTime, | |
'EXEC msdb.dbo.sp_start_job N''' + CAST(sch.ScheduleID as nvarchar(36)) + ''' ;' AS StartJob, | |
'EXEC msdb.dbo.sp_update_job @job_name = N' + CAST(sch.ScheduleID as nvarchar(36)) + ', @enabled = 1 ;' AS EnableJob, | |
'EXEC msdb.dbo.sp_update_job @job_name = N' + CAST(sch.ScheduleID as nvarchar(36)) + ', @enabled = 0 ;' AS DisableJob |