Skip to content

Quick Search: add SQL Agent Job Steps search, Script action and UI tweaks#66

Merged
alex-bochkov merged 2 commits intosql-searchfrom
codex/add-search-functionality-to-sql-agent-job-steps
Feb 13, 2026
Merged

Quick Search: add SQL Agent Job Steps search, Script action and UI tweaks#66
alex-bochkov merged 2 commits intosql-searchfrom
codex/add-search-functionality-to-sql-agent-job-steps

Conversation

@alex-bochkov
Copy link
Copy Markdown
Contributor

Motivation

  • Provide the ability to search SQL Server Agent job step text alongside database objects so quick search can find job-step commands and names.
  • Avoid showing stale results while a new search is running by clearing the grid at search start and surface the result count in a persistent status area.
  • Make the results easier to read with a fixed-width font and add a simple scripting action hook for future integration.

Description

  • Add a new CheckBox_AgentJobSteps option and implement SearchAgentJobSteps which queries msdb..sysjobs/sysjobsteps and returns unified rows for the results grid.
  • Extend the result model with ScriptDatabaseName, ScriptSchemaName, and ScriptObjectName fields and return those from both regular object queries and job-step queries.
  • Clear previous results early by setting DataGrid_SearchResults.ItemsSource = null at search start and move TextBlock_ResultCount into a bottom StatusBar to show counts there.
  • Add a Script DataGridTemplateColumn with a Button_ScriptResult_Click handler and a ScriptObjectPlaceholder function that receives database/schema/object names; set the grid FontFamily to Cascadia Mono.

Testing

  • Attempted to build the solution with dotnet build AxialSqlTools/AxialSqlTools.sln, but the build could not be run in this environment because dotnet is not installed, so compilation was not verified.
  • Local static checks and manual file validation were performed by updating the XAML and code-behind and running repository diffs to confirm the intended changes were applied successfully.

Codex Task

@alex-bochkov alex-bochkov merged commit 933e371 into sql-search Feb 13, 2026
@alex-bochkov alex-bochkov deleted the codex/add-search-functionality-to-sql-agent-job-steps branch February 13, 2026 01:10
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Labels

Projects

None yet

Development

Successfully merging this pull request may close these issues.

1 participant