Microsoft.SqlServer.Dacpacs.Msdb
170.0.2
Prefix Reserved
dotnet add package Microsoft.SqlServer.Dacpacs.Msdb --version 170.0.2
NuGet\Install-Package Microsoft.SqlServer.Dacpacs.Msdb -Version 170.0.2
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Msdb" Version="170.0.2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="Microsoft.SqlServer.Dacpacs.Msdb" Version="170.0.2" />
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Msdb" />
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add Microsoft.SqlServer.Dacpacs.Msdb --version 170.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Microsoft.SqlServer.Dacpacs.Msdb, 170.0.2"
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package Microsoft.SqlServer.Dacpacs.Msdb@170.0.2
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=Microsoft.SqlServer.Dacpacs.Msdb&version=170.0.2
#tool nuget:?package=Microsoft.SqlServer.Dacpacs.Msdb&version=170.0.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
Microsoft.SqlServer.Dacpacs.Msdb contains a .dacpac file for the SQL Server msdb objects. Referencing this package in a SQL database project allows you to build and validate database projects with msdb object references that target SQL Server.
📗 SQL projects database DevOps documentation
Usage
The reference to this package can be added to your SQL database project (.sqlproj) as follows:
...
<ItemGroup>
<PackageReference Include="Microsoft.SqlServer.Dacpacs.Msdb" Version="170.0.2" />
</ItemGroup>
</Project>
An example of a SQL Server msdb objects referenced in a SQL database project is shown below:
CREATE VIEW dbo.v_JobLastRunStatus
AS
WITH JobHistory AS (
SELECT
j.job_id,
j.name AS job_name,
h.run_date,
h.run_time,
h.run_status,
h.message,
ROW_NUMBER() OVER (
PARTITION BY j.job_id
ORDER BY
h.run_date DESC,
h.run_time DESC
) AS rn
FROM msdb.dbo.sysjobs j
JOIN msdb.dbo.sysjobhistory h
ON j.job_id = h.job_id
WHERE h.step_id = 0
)
SELECT
job_name,
run_status,
CASE run_status
WHEN 0 THEN 'Failed'
WHEN 1 THEN 'Succeeded'
WHEN 2 THEN 'Retry'
WHEN 3 THEN 'Canceled'
ELSE 'Unknown'
END AS run_status_desc,
run_date,
run_time,
message
FROM JobHistory
WHERE rn = 1;
Related packages
| Package | Target platforms | Description |
|---|---|---|
| Microsoft.SqlServer.Dacpacs.Azure.Master | Azure SQL Database | Microsoft.SqlServer.Dacpacs.Azure.Master is a NuGet package containing a .dacpac file for the Azure SQL Database master database. |
| Microsoft.SqlServer.Dacpacs.DbFabric | SQL database in Fabric | Microsoft.SqlServer.Dacpacs.DbFabric is a NuGet package containing a .dacpac file for the SQL database in Fabric system objects. |
| Microsoft.SqlServer.Dacpacs.FabricDw | Data warehouse in Fabric | Microsoft.SqlServer.Dacpacs.FabricDw is a NuGet package containing a .dacpac file for the Data warehouse in Fabric system objects. |
| Microsoft.SqlServer.Dacpacs.Master | SQL Server | Microsoft.SqlServer.Dacpacs.Master is a set of NuGet packages containing .dacpac files for Microsoft SQL Server master databases. |
| Microsoft.SqlServer.Dacpacs.Synapse.Master | Azure Synapse Analytics | Microsoft.SqlServer.Dacpacs.Synapse.Master is a NuGet package containing a .dacpac file for the Azure Synapse Analytics master database. |
| Microsoft.SqlServer.Dacpacs.SynapseServerless.Master | Azure Synapse Analytics serverless pools | Microsoft.SqlServer.Dacpacs.SynapseServerless.Master is a NuGet package containing a .dacpac file for the Azure Synapse Analytics serverless SQL pools master database. |
There are no supported framework assets in this package.
Learn more about Target Frameworks and .NET Standard.
-
.NETFramework 4.7.2
- No dependencies.
-
.NETStandard 2.0
- No dependencies.
-
net10.0
- No dependencies.
-
net8.0
- No dependencies.
NuGet packages
This package is not used by any NuGet packages.
GitHub repositories
This package is not used by any popular GitHub repositories.
| Version | Downloads | Last Updated |
|---|---|---|
| 170.0.2 | 1,826 | 2/10/2026 |
| 170.0.1 | 1,306 | 7/30/2025 |
| 170.0.0 | 1,173 | 4/15/2025 |
| 160.1.3 | 2,659 | 7/30/2025 |
| 160.1.2 | 8,101 | 9/20/2024 |
| 160.1.1 | 809 | 3/1/2024 |
| 160.1.0 | 1,017 | 10/19/2023 |
| 160.0.0 | 27,271 | 5/12/2023 |
| 150.0.1 | 3,438 | 7/30/2025 |
| 150.0.0 | 27,478 | 5/12/2023 |
| 140.0.4 | 506 | 7/30/2025 |
| 140.0.3 | 539 | 4/15/2025 |
| 140.0.1 | 1,134 | 3/1/2024 |
| 140.0.0 | 17,227 | 5/12/2023 |
| 130.1.2 | 458 | 7/30/2025 |
| 130.1.1 | 1,007 | 3/1/2024 |
| 130.1.0 | 490 | 2/27/2024 |
| 130.0.0 | 4,756 | 5/12/2023 |
| 120.0.2 | 453 | 7/30/2025 |
| 120.0.1 | 545 | 3/1/2024 |
Loading failed