salt
1.1.3806.0
Module to deploy SQL Agent Jobs to SQL Server Instance.
Supports creation of jobs, schedules and job steps of type SQL, PowerShell
and dtsx packages. Requires the SQl Agent Job to be in a set format in XML.
Requires SMO to be installed on box.
Installation Options
Owners
Copyright
Sabin.IO 2017
Package Details
Author(s)
- Richie Lee
Functions
Get-Job Get-SqlAgentAsXml Get-Xml Connect-SqlConnection Disable-Job Disable-JobNotifications Disable-JobSchedules Disconnect-SqlConnection Enable-Job Enable-JobSchedules Set-Job Set-JobCategory Set-JobNotification Set-JobOperator Set-JobOwner Set-JobProperties Set-JobSchedules Set-JobSteps Test-JobIsIdle Test-CurrentPermissions Test-SQLServerAgentService
Dependencies
This module has no dependencies.
FileList
- salt.nuspec
- README.md
- salt.psd1
- salt.psm1
- functions\ConnectSqlConnection.ps1
- functions\DisableJob.ps1
- functions\DisableJobNotifications.ps1
- functions\DisableJobSchedules.ps1
- functions\DisconnectSqlConnection.ps1
- functions\EnableJob.ps1
- functions\EnableJobSchedules.ps1
- functions\GetDaysofWeek.ps1
- functions\GetFrequencyIntervalValue.ps1
- functions\GetGoToStepId.ps1
- functions\GetGoToStepName.ps1
- functions\GetJob.ps1
- functions\GetJobCurrentRunStatus.ps1
- functions\GetSqlAgentAsXml.ps1
- functions\GetSumUp.ps1
- functions\GetXml.ps1
- functions\SetIscVariables.ps1
- functions\SetJob.ps1
- functions\SetJobCategory.ps1
- functions\SetJobNotification.ps1
- functions\SetJobOperator.ps1
- functions\SetJobOwner.ps1
- functions\SetJobProperties.ps1
- functions\SetJobSchedules.ps1
- functions\SetJobSteps.ps1
- functions\SetRunAsAccounts.ps1
- functions\TestCurrentPermissions.ps1
- functions\TestJobIsIdle.ps1
- functions\TestSqlServerAgentService.ps1
Version History
Version | Downloads | Last updated |
---|---|---|
2.0.7792.0 | 2,207 | 3/8/2021 |
2.0.7760.0 | 252 | 3/3/2021 |
2.0.7755.0 | 15 | 3/3/2021 |
2.0.7754.0 | 15 | 3/3/2021 |
2.0.4933.0 | 256 | 4/4/2019 |
2.0.4888.0 | 18 | 4/3/2019 |
2.0.4884.0 | 16 | 4/3/2019 |
1.1.3844.0 | 76 | 8/28/2018 |
1.1.3806.0 (current version) | 35 | 7/16/2018 |
1.1.3804.0 | 19 | 7/16/2018 |
1.1.3802.0 | 18 | 7/16/2018 |
1.1.2562.0 | 110 | 1/9/2018 |
1.1.2384.0 | 42 | 11/22/2017 |
1.1.2371.0 | 18 | 11/21/2017 |
1.1.2369.0 | 18 | 11/21/2017 |
1.1.2367.0 | 19 | 11/21/2017 |
1.1.2365.0 | 19 | 11/21/2017 |
1.1.2364.0 | 19 | 11/21/2017 |
1.1.2363.0 | 18 | 11/21/2017 |
1.0.2328.0 | 21 | 11/14/2017 |
1.0.2327.0 | 18 | 11/14/2017 |
1.0.2325.0 | 18 | 11/14/2017 |
1.0.2322.0 | 19 | 11/13/2017 |
1.0.2320.0 | 19 | 11/13/2017 |
1.0.2318.0 | 19 | 11/9/2017 |
1.0.2.1 | 24 | 11/6/2017 |
1.0.2.0 | 18 | 11/6/2017 |
1.0.1.0 | 20 | 11/2/2017 |
1.0.0.1 | 26 | 10/24/2017 |