# System Configuration

Published articles for System Configuration.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Creating Idempotent SQL Server Agent Job Scripts

DevFeed: [Creating Idempotent SQL Server Agent Job Scripts](<https://devfeed.tech/articles/a-script-to-script-a-script-that-scripts-jobs-50497.md>)

Original publisher: [Read original article](<https://sqlperformance.com/2026/08/sql-job/idempotent-script>)

Author: Aaron Bertrand

Published: 2026-08-18T09:01:07Z

Content type: article

Language: en

Sources: [SQLPerformance.com](<https://devfeed.tech/sources/sqlperformance-com.md>)

Topics: [Deployment](<https://devfeed.tech/topics/deployment.md>), [sql-server](<https://devfeed.tech/topics/sql-server.md>), [SQL](<https://devfeed.tech/topics/sql.md>), [Automation](<https://devfeed.tech/topics/automation.md>), [Error Handling](<https://devfeed.tech/topics/error-handling.md>), [configuration](<https://devfeed.tech/topics/configuration.md>)

Tags: [automation](<https://devfeed.tech/tags/automation.md>), [configuration](<https://devfeed.tech/tags/configuration.md>), [deployment](<https://devfeed.tech/tags/deployment.md>), [error-handling](<https://devfeed.tech/tags/error-handling.md>), [script](<https://devfeed.tech/tags/script.md>), [scripting](<https://devfeed.tech/tags/scripting.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sql-job](<https://devfeed.tech/tags/sql-job.md>), [sql-server](<https://devfeed.tech/tags/sql-server.md>), [sql-server-agent](<https://devfeed.tech/tags/sql-server-agent.md>), [system-configuration](<https://devfeed.tech/tags/system-configuration.md>)

### AI overview

The article presents a stored procedure for generating idempotent SQL Server Agent job scripts. It discusses problems with SSMS-generated scripts, including hard-coded schedule identifiers, missing existence checks, outdated error handling, excessive control flow, and environment-specific values.

### Source excerpt

Aaron Bertrand shows a stored procedure he wrote to make scripting SQL Server Agent jobs idempotent and avoid schedule spaghetti. The post A script to script a script that scripts jobs appeared first on SQLPerformance.com.