Microsoft.SqlServer.Dacpacs.Msdb
170.0.3
Prefix Reserved
dotnet add package Microsoft.SqlServer.Dacpacs.Msdb --version 170.0.3
NuGet\Install-Package Microsoft.SqlServer.Dacpacs.Msdb -Version 170.0.3
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.3" />
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.3" />
<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.3
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
#r "nuget: Microsoft.SqlServer.Dacpacs.Msdb, 170.0.3"
#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.3
#: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.3
#tool nuget:?package=Microsoft.SqlServer.Dacpacs.Msdb&version=170.0.3
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.3" />
</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.3 | 5,622 | 2026/6/3 |
| 170.0.2 | 4,800 | 2026/2/10 |
| 170.0.1 | 1,650 | 2025/7/30 |
| 170.0.0 | 3,589 | 2025/4/15 |
| 160.1.4 | 6,450 | 2026/6/3 |
| 160.1.3 | 5,816 | 2025/7/30 |
| 160.1.2 | 10,299 | 2024/9/20 |
| 160.1.1 | 977 | 2024/3/1 |
| 160.1.0 | 1,176 | 2023/10/19 |
| 160.0.0 | 35,149 | 2023/5/12 |
| 150.0.1 | 5,138 | 2025/7/30 |
| 150.0.0 | 44,358 | 2023/5/12 |
| 140.0.4 | 1,018 | 2025/7/30 |
| 140.0.3 | 704 | 2025/4/15 |
| 140.0.1 | 1,403 | 2024/3/1 |
| 130.1.2 | 847 | 2025/7/30 |
| 130.1.1 | 1,355 | 2024/3/1 |
| 130.1.0 | 697 | 2024/2/27 |
| 120.0.2 | 641 | 2025/7/30 |
| 120.0.1 | 706 | 2024/3/1 |
Loading failed