๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ 76

[SQL Server] ์—์ด์ „ํŠธ๋กœ ์ผ์ • ์ž‘์—… ์ž๋™ํ™”ํ•˜๊ธฐ

์šด์˜ ์—…๋ฌด๋ฅผ ํ•˜๋‹ค ๋ณด๋ฉด ๋งค๋ฒˆ ๋™์ผํ•œ ์ฟผ๋ฆฌ๋ฅผ ์‹คํ–‰ํ•ด์•ผ ํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์Šต๋‹ˆ๋‹ค. ์ด๋Ÿด ๋•Œ SQL Server Management Studio(SSMS)์—์„œ ์ œ๊ณตํ•˜๋Š” SQL Server ์—์ด์ „ํŠธ๋ฅผ ํ™œ์šฉํ•˜๋ฉด, ์›ํ•˜๋Š” ์‹œ๊ฐ„์— ์ฟผ๋ฆฌ๋ฅผ ์ž๋™์œผ๋กœ ์‹คํ–‰ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์˜ค๋Š˜ ์˜คํ›„ 2์‹œ์— ํŠน์ • ์ฟผ๋ฆฌ๊ฐ€ ์ˆ˜ํ–‰๋˜๋„๋ก ์ž‘์—…์„ ์„ค์ •ํ•˜๊ณ , ๊ทธ ๊ณผ์ •์„ ์•„๋ž˜ ์ •๋ฆฌํ•˜์˜€์Šต๋‹ˆ๋‹ค. ๐Ÿ“‚ ๋ชฉ์ฐจ SQL Server ์—์ด์ „ํŠธ๋ž€? SQL Server ์—์ด์ „ํŠธ(SQL Server Agent) ๋Š” SQL Server์—์„œ ์ œ๊ณตํ•˜๋Š” ์ž‘์—… ์Šค์ผ€์ค„๋Ÿฌ์ž…๋‹ˆ๋‹ค.๋ชจ๋“  ์ผ์ • ๊ด€๋ จ ์ •๋ณด๋Š” msdb ์‹œ์Šคํ…œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์— ๊ธฐ๋ก๋ฉ๋‹ˆ๋‹ค.๋”ฐ๋ผ์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์—”์ง„์ด ์ข…๋ฃŒ๋˜๋ฉด ์—์ด์ „ํŠธ๋„ ํ•จ๊ป˜ ์‚ฌ์šฉํ•  ์ˆ˜ ์—†๊ฒŒ ๋ฉ๋‹ˆ๋‹ค. (๋‹จ, ์—์ด์ „ํŠธ๊ฐ€ ์ข…๋ฃŒ๋˜์—ˆ๋‹ค๊ณ  ํ•ด์„œ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ์—”์ง„์ด ๊ฐ™์ด ์ข…๋ฃŒ๋˜๋Š”..

SQL Server 2025.09.02

[JavaScript] ๋ฐ˜๋ณต๋˜๋Š” ์ฝ”๋“œ๋ฅผ ์ „์—ญ ๊ณตํ†ต ์ปดํฌ๋„ŒํŠธ๋กœ ๊ฐœ์„ ํ•˜๊ธฐ

์›น ํ”„๋กœ์ ํŠธ๋ฅผ ์ง„ํ–‰ํ•˜๋‹ค ๋ณด๋ฉด ๋ฉ”์ธ ํŽ˜์ด์ง€, ์ด๋ฒคํŠธ ํŽ˜์ด์ง€ ๋“ฑ ์—ฌ๋Ÿฌ ํ™”๋ฉด์—์„œ ๋™์ผํ•œ HTML ๊ตฌ์กฐ๊ฐ€ ๋ฐ˜๋ณต์ ์œผ๋กœ ๋“ฑ์žฅํ•˜๋Š” ๊ฒฝ์šฐ๊ฐ€ ๋งŽ์Šต๋‹ˆ๋‹ค. ์ด๋Ÿฐ ์ฝ”๋“œ๋ฅผ ๊ทธ๋Œ€๋กœ ๋‘๋ฉด ์œ ์ง€๋ณด์ˆ˜๊ฐ€ ์–ด๋ ค์›Œ์ง€๊ณ , ์ƒˆ๋กœ์šด ์š”๊ตฌ์‚ฌํ•ญ์ด ์ƒ๊ฒผ์„ ๋•Œ ๋ชจ๋“  ํŽ˜์ด์ง€๋ฅผ ์ˆ˜์ •ํ•ด์•ผ ํ•˜๋Š” ๋ถˆํŽธํ•จ์ด ์ƒ๊น๋‹ˆ๋‹ค.์ด๋ฒˆ ์ž‘์—…์—์„œ๋Š” ์ด๋Ÿฌํ•œ ๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•˜๊ธฐ ์œ„ํ•ด, ๋ฐ˜๋ณต๋˜๋Š” ์ฝ”๋“œ๋ฅผ ์ „์—ญ ์ž๋ฐ”์Šคํฌ๋ฆฝํŠธ ์ปดํฌ๋„ŒํŠธ๋กœ ๋ชจ๋“ˆํ™”ํ•˜์—ฌ ๊ณตํ†ต์œผ๋กœ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋„๋ก ๊ฐœ์„ ํ–ˆ์Šต๋‹ˆ๋‹ค. ๐Ÿ“‚ ๋ชฉ์ฐจ 1. ์ „์—ญ ๋„ค์ž„์ŠคํŽ˜์ด์Šค ํŒจํ„ดwindow.RentalComponents = window.RentalComponents || {};์ „์—ญ ๋ณ€์ˆ˜ ์˜ค์—ผ(Global Pollution) ๋ฐฉ์ง€.window ๊ฐ์ฒด์— RentalComponents๋ผ๋Š” ๋„ค์ž„์ŠคํŽ˜์ด์Šค๋ฅผ ์ •์˜ํ•˜์—ฌ ๋ชจ๋“  ํ•จ์ˆ˜๋ฅผ ์ด ์•ˆ์— ๋ชจ์•„ ๊ด€๋ฆฌ์ด๋ฏธ ์„ ์–ธ๋œ..

DevLog 2025.08.22

[CLS ๊ฐœ์„ ] Lighthouse ์„ฑ๋Šฅ ๊ฐœ์„  ๊ธฐ๋ก: 76์  → 82์ ๊นŒ์ง€ ์˜ฌ๋ฆฐ ๊ณผ์ •

ํšŒ์‚ฌ ์‚ฌ์ดํŠธ์˜ ์›นํŽ˜์ด์ง€ ํ’ˆ์งˆ์„ ์ธก์ •ํ•˜๊ณ  ๊ฐœ์„ ํ•˜๊ธฐ ์œ„ํ•ด Google Lighthouse๋ฅผ ํ™œ์šฉํ–ˆ์Šต๋‹ˆ๋‹ค.์ตœ์ดˆ ์ธก์ • ๊ฒฐ๊ณผ ์„ฑ๋Šฅ ์ ์ˆ˜ 76์ ์„ ๋ฐ›์•˜๊ณ , Lighthouse์—์„œ ์ œ์•ˆํ•œ ๊ฐœ์„  ์‚ฌํ•ญ ์ค‘ ์ผ๋ถ€๋ฅผ ์ ์šฉํ•˜์—ฌ 82์ ๊นŒ์ง€ ๋Œ์–ด์˜ฌ๋ฆด ์ˆ˜ ์žˆ์—ˆ์Šต๋‹ˆ๋‹ค. ์ด๋ฒˆ ๊ธ€์—์„œ๋Š” ๊ตฌ์ฒด์ ์œผ๋กœ ์–ด๋–ค ๋ถ€๋ถ„์„ ๊ฐœ์„ ํ–ˆ๋Š”์ง€, ๊ทธ๋ฆฌ๊ณ  ๊ทธ ๊ณผ์ •์—์„œ ์–ด๋–ค ์ ์„ ๊ณ ๋ คํ–ˆ๋Š”์ง€ ์ •๋ฆฌํ•ด๋ณด๊ฒ ์Šต๋‹ˆ๋‹ค. ๐Ÿ“‚ ๋ชฉ์ฐจ 1. Lighthouse์—์„œ ์ œ์•ˆํ•œ ๊ฐœ์„  ํ•ญ๋ชฉLighthouse๋Š” ์›นํŽ˜์ด์ง€ ์„ฑ๋Šฅ ์ €ํ•˜ ์š”์ธ์œผ๋กœ ์—ฌ๋Ÿฌ ํ•ญ๋ชฉ์„ ์ œ์•ˆํ–ˆ์œผ๋ฉฐ, ์ด ์ค‘ ๋‘ ๊ฐ€์ง€๋ฅผ ์ฃผ์š” ๊ฐœ์„  ํฌ์ธํŠธ๋กœ ์„ ์ •ํ–ˆ์Šต๋‹ˆ๋‹ค. ์ด๋ฏธ์ง€ ์š”์†Œ์— width ๋ฐ height ์†์„ฑ์ด ๋ช…์‹œ๋˜์ง€ ์•Š์ŒCSS ํŒŒ์ผ ์ตœ์ ํ™”(์ถ•์†Œ ๋ฐ ์ค‘๋ณต ์ œ๊ฑฐ ํ•„์š”)์ด ๋‘ ๊ฐ€์ง€๋Š” ๋‹จ์ˆœํ•ด ๋ณด์ด์ง€๋งŒ ์‹ค์ œ๋กœ๋Š” CLS(Cumulative ..

DevLog 2025.08.20

[Jenkins] Jenkins SSH ๋ฐฐํฌ ์˜ค๋ฅ˜ ์›์ธ ๋ถ„์„

Jenkins์—์„œ SSH๋ฅผ ํ†ตํ•ด ์šด์˜ ์„œ๋ฒ„๋กœ ๋ฐฐํฌํ•˜๋Š” ๊ณผ์ •์—์„œ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒ ๐Ÿ“‚ ๋ชฉ์ฐจ [์ด์Šˆ ๋ถ„์„] Jenkins SSH ๋ฐฐํฌ ์‹คํŒจ ์›์ธ: ์„œ๋น„์Šค ๊ณ„์ • ์‚ญ์ œjenkins.plugins.publish_over.BapPublisherException: Failed to connect and initialize SSH connection. Message: [Auth fail for methods 'publickey,password,keyboard-interactive'] ๐Ÿ” ๋ฌธ์ œ ์ƒํ™ฉJenkins๋Š” ๋‚ด๋ถ€ ์„œ๋ฒ„(`XXX.XXX.XXX.XXX`)์— SSH๋กœ ์ ‘์†ํ•˜์—ฌ ํŒŒ์ผ์„ ๋ฐฐํฌํ•˜๊ณ  ์žˆ์—ˆ์Œ์„ค์ •๋œ ๊ณ„์ •์€ `cicd`๋ผ๋Š” ์ „์šฉ ์„œ๋น„์Šค ๊ณ„์ •Jenkins์™€ ์„œ๋ฒ„ ๊ฐ„ ๋„คํŠธ์›Œํฌ, ํฌํŠธ, ๋น„๋ฐ€๋ฒˆํ˜ธ ๋ชจ๋‘ ์ •์ƒ ..

์œˆ๋„์šฐ์—์„œ ๊ฐ€์ƒ ์–ด๋Œ‘ํ„ฐ(VMware, Hyper-V ๋“ฑ) IP ํ™•์ธ

windows์—์„œ ์„ค์ •๋œ ๊ฐ€์ƒ ๋„คํŠธ์›Œํฌ ์–ด๋Œ‘ํ„ฐ๋“ค์˜ IP์ฃผ์†Œ ํ™•์ธํ•˜๋Š” ๋ฐฉ๋ฒ•๐Ÿ“‚ ๋ชฉ์ฐจ ์ œ์–ดํŒ > ๋„คํŠธ์›Œํฌ ์–ด๋Œ‘ํ„ฐ ์„ค์ • ํ™”๋ฉดโ–ถ ๋ฐฉ๋ฒ•:1. Win + R → ncpa.cpl ์ž…๋ ฅ 2. ๋„คํŠธ์›Œํฌ ์—ฐ๊ฒฐ ์ฐฝ ํ™•์ธ ์ด๊ณณ์—์„œ ์‹ค์ œ ์œ ์„ /๋ฌด์„  LAN ์™ธ์— VMware, Hyper-V, VirtualBox, Docker, WSL, VPN, Loopback ์–ด๋Œ‘ํ„ฐ ๋“ฑ ๋‹ค์–‘ํ•œ ๊ฐ€์ƒ ๋„คํŠธ์›Œํฌ ์–ด๋Œ‘ํ„ฐ๋ฅผ ๋ณผ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ๊ฐ ์–ด๋Œ‘ํ„ฐ ๋”๋ธ”ํด๋ฆญ → "์ƒ์„ธ ์ •๋ณด" ๋ฒ„ํŠผ ํด๋ฆญ → IP ์ฃผ์†Œ ํ™•์ธ ๊ฐ€๋Šฅ

[git] GitHub Push ๊ถŒํ•œ ์˜ค๋ฅ˜ ๋ฐœ์ƒ (403 Error)

403 ์—๋Ÿฌ๋Š” ์ธ์ฆ(Authorization) ๋ฌธ์ œ๊ฐ€ ๋ฐœ์ƒ๋ฌธ์ œ ๋‚ด์šฉ์„ ๋ณด๋ฉด, hyonieKim ์ด๋ผ๋Š” ์‚ฌ์šฉ์ž ๊ณ„์ •์œผ๋กœ hyonie-Kim๋ ˆํฌ์ง€ํ† ๋ฆฌ์— push ํ•˜๋ ค๋‹ค ๊ถŒํ•œ์ด ์—†์–ด์„œ ๊ฑฐ์ ˆ๋จ ๐Ÿ“‚ ๋ชฉ์ฐจ GitHub Push ์‹œ 403 ์˜ค๋ฅ˜ ๋ฐœ์ƒ ๋ฐ ํ•ด๊ฒฐ ๊ณผ์ • ์›์ธ ์š”์•ฝ- ๊นƒํ—ˆ๋ธŒ์—์„œ hyonieKim ๊ณ„์ •์€ hyonie-Kim/ksh-portfolio ์ €์žฅ์†Œ์— push ๊ถŒํ•œ์ด ์—†์Œ - ๋˜๋Š” GitHub์— ๋กœ๊ทธ์ธ๋œ ๊ณ„์ •๊ณผ ๋กœ์ปฌ Git์—์„œ ์ธ์ฆ๋œ ๊ณ„์ •์ด ๋ถˆ์ผ์น˜ํ•  ์ˆ˜ ์žˆ์Œ. ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•- ๊นƒํ—ˆ๋ธŒ ์ €์žฅ์†Œ ๊ถŒํ•œ ํ™•์ธ - ํ•ด๋‹น ๋ ˆํฌ์ง€ํ† ๋ฆฌ์˜ Settings > Collaborators ์—์„œ hyonieKim ๊ณ„์ •์ด collaborator๋กœ ๋“ฑ๋ก๋˜์–ด ์žˆ๋Š”์ง€ ํ™•์ธ - ์•„๋‹ˆ๋ผ๋ฉด ๋ณธ์ธ ๊ณ„์ •(hyonieKim)์œผ๋กœ๋Š” push ๊ถŒํ•œ์ด ..

[ASP.NET] ์ปดํŒŒ์ผ๋Ÿฌ ์˜ค๋ฅ˜ ๋ฉ”์‹œ์ง€: CS0123: 'System.EventHandler' ๋Œ€๋ฆฌ์ž์™€ ์ผ์น˜ํ•˜๋Š” ์˜ค๋ฒ„๋กœ๋“œ๊ฐ€ ์—†์Šต๋‹ˆ๋‹ค.

๋ฒ„ํŠผ์„ ํด๋ฆญ ์‹œ, ์ปดํŒŒ์ผ ์˜ค๋ฅ˜ ๋ฉ”์‹œ์ง€๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค.์˜ค๋ฅ˜์˜ ์›์ธ์€ ASP.NET์—์„œ ์˜ OnClick ์ด๋ฒคํŠธ๋Š” ๋‹ค์Œ ์‹œ๊ทธ๋‹ˆ์ฒ˜๋ฅผ ๊ฐ€์ง„ ๋ฉ”์„œ๋“œ๋งŒ ํ—ˆ์šฉํ•œ๋‹ค.protected void btnSubmit_Click() ์ด๋ ‡๊ฒŒ ์ž‘์„ฑํ•ด์„œ ๋‚œ์˜ค๋ฅ˜.. ์ž๋ฐ”์Šคํฌ๋ฆฝํŠธ๊ฐ€ ํŽธํ•˜๋‹ค.๐Ÿ˜ข ๐Ÿ“‚ ๋ชฉ์ฐจ asp:Button OnClick ์ด๋ฒคํŠธ๋Š” ์‹œ๊ทธ๋‹ˆ์ฒ˜๋ฅผ ๊ฐ€์ง„ ๋ฉ”์„œ๋“œ๋กœ ์ˆ˜์ •์•„๋ž˜์ฒ˜๋Ÿผ ์ˆ˜์ •protected void btnSubmit_Click(object sender, EventArgs e){ // ์ฒ˜๋ฆฌ ๋กœ์ง}protected: Page ๋‚ด๋ถ€์—์„œ ํ˜ธ์ถœ ๊ฐ€๋Šฅํ•ด์•ผ ํ•˜๋ฏ€๋กœ ์ ์ ˆvoid: ๋ฐ˜ํ™˜๊ฐ’ ์—†์Œobject sender, EventArgs e: ์ด๋ฒคํŠธ ์ฒ˜๋ฆฌ ๊ธฐ๋ณธ ๊ตฌ์กฐ

C# 2025.07.25

[ASP.NET] ์ปดํŒŒ์ผ๋Ÿฌ ์˜ค๋ฅ˜ ๋ฉ”์‹œ์ง€: CS1056: ์˜ˆ๊ธฐ์น˜ ์•Š์€ '$' ๋ฌธ์ž์ž…๋‹ˆ๋‹ค.

์ถ”๊ฐ€ ๋ฒ„ํŠผ ์ด๋ฒคํŠธ ๋ฐœ์ƒ ์‹œ insert ํ•˜๋Š”๋ฐ, ์˜ค๋ฅ˜๊ฐ€ ๋ฐœ์ƒํ–ˆ๋‹ค. ๋ฌธ์ œ๋Š” $"..." ํ˜•์‹์˜ ๋ฌธ์ž์—ด ๋ณด๊ฐ„(String Interpolation) ์€ C# 6.0 ์ด์ƒ์—์„œ ๋„์ž…๋œ ๋ฌธ๋ฒ•์ด๊ธฐ ๋•Œ๋ฌธ์ด๋‹ค. ์‚ฌ์šฉํ•˜๋Š” ํ”„๋กœ์ ํŠธ๋Š” ASP.NET 4.0์€ ๊ธฐ๋ณธ์ ์œผ๋กœ C# 4.0์„ ์‚ฌ์šฉํ•˜๋ฏ€๋กœ, ์ด ๋ฌธ๋ฒ•์€ ์ปดํŒŒ์ผ ์˜ค๋ฅ˜(CS1056) ๋ฅผ ๋ฐœ์ƒ์‹œํ‚ค๋Š” ๋ฌธ์ œ์˜€๋‹ค.๐Ÿ“‚ ๋ชฉ์ฐจ ํ•ด๊ฒฐ ๋ฐฉ๋ฒ•: string.Format() ๋˜๋Š” ๋ฌธ์ž์—ด ์—ฐ๊ฒฐ ์‚ฌ์šฉโ–ถ ๊ธฐ์กด ์ฝ”๋“œ(์˜ค๋ฅ˜ ๋ฐœ์ƒ)string planId = Request.Form[$"planId_{index}"]; ์ˆ˜์ • 1 : string.Format ์‚ฌ์šฉ string planId = Request.Form[string.Format("planId_{0}", index)]; ์ˆ˜์ • 2 : ๋ฌธ์ž์—ด ..

C# 2025.07.25

[Excel] ์—‘์…€์—์„œ SQL Server ๋ฐ์ดํŠธ๋ฒ ์ด์Šค ์—ฐ๊ฒฐํ•˜๊ณ  ๋ฐ์ดํ„ฐ ๊ฐ€๊ณตํ•˜๊ธฐ

์—‘์…€๊ณผ SQL Server๋ฅผ ์—ฐ๋™ํ•˜๋ฉด DB ๋ฐ์ดํ„ฐ๋ฅผ ์ง์ ‘ ๋ถˆ๋Ÿฌ์™€ ์‹ค์‹œ๊ฐ„ ๋ถ„์„์ด๋‚˜ ๋ณด๊ณ ์„œ ์ž‘์„ฑ์ด ๋งค์šฐ ํŽธ๋ฆฌํ•ด์ง‘๋‹ˆ๋‹ค.์ด ๊ธ€์—์„œ๋Š” ์—‘์…€์—์„œ SQL Server์— ์—ฐ๊ฒฐํ•˜์—ฌ ์ฟผ๋ฆฌ ๊ฒฐ๊ณผ๋ฅผ ๋ถˆ๋Ÿฌ์˜ค๊ณ , ์„ฑ๋ณ„ ๋ฐ์ดํ„ฐ๋ฅผ ๊ฐ€๊ณตํ•˜๊ณ , ๋ˆˆ๊ธˆ์„ ์„ ์ œ๊ฑฐํ•ด ๋ณด๊ณ ์„œ์ฒ˜๋Ÿผ ์ถœ๋ ฅํ•˜๋Š” ๋ฐฉ๋ฒ•๊นŒ์ง€ ์†Œ๊ฐœํ•ฉ๋‹ˆ๋‹ค.๐Ÿ“‚ ๋ชฉ์ฐจ 1. ์—‘์…€์—์„œ SQL Server ์—ฐ๊ฒฐํ•˜๊ธฐ๐ŸŸฉ ๊ฒฝ๋กœ[๋ฐ์ดํ„ฐ] > [๋ฐ์ดํ„ฐ ๊ฐ€์ ธ์˜ค๊ธฐ] > [๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ] > [SQL Server ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ] โœ… ์ž…๋ ฅ ํ•ญ๋ชฉ ์„ค๋ช… ํ•ญ๋ชฉ์„ค๋ช…์„œ๋ฒ„SQL Server ์ธ์Šคํ„ด์Šค๋ช… (*์ ‘์†ํ•˜๋ ค๋Š” ์„œ๋ฒ„ ์ด๋ฆ„ ๋˜๋Š” IP์ฃผ์†Œ)๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์‚ฌ์šฉํ•  DB ์ด๋ฆ„ (์ž…๋ ฅ ์•ˆํ•ด๋„ ๋˜์ง€๋งŒ, ์ž…๋ ฅํ•˜๋ฉด ํ•ด๋‹น DB๋กœ ๋ฐ”๋กœ ์—ฐ๊ฒฐ๋จ!)๋ช…๋ น ์‹œ๊ฐ„ ์ œํ•œ(๋ถ„)์ฟผ๋ฆฌ ์‹คํ–‰์ด ์ง€์ • ์‹œ๊ฐ„ ์ดˆ๊ณผ๋˜๋ฉด ์ค‘๋‹จ - ๊ธฐ๋ณธ๊ฐ’์€ 0 (๋ฌด์ œํ•œ)- ์ผ๋ฐ˜์ ์œผ..

DB 2025.07.24

[SQL Server] SQL Server Agent ์‹คํ–‰์ด ์•ˆ๋  ๋•Œ - DCOM/๋ ˆ์ง€์ŠคํŠธ๋ฆฌ ๊ถŒํ•œ ๋ฌธ์ œ

SQL Server Agent ์„œ๋น„์Šค๊ฐ€ ์‹คํ–‰๋˜๋„๋ก ์„ค์ •ํ•ด์„œ, ์ž‘์—…(Job) ๋“ฑ์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋„๋ก ๋งŒ๋“ค๋ ค๊ณ  ํ–ˆ๋Š”๋ฐ,,, ๋‚ด PC ๊ฐœ๋ฐœํ™˜๊ฒฝ ๋กœ์ปฌ์—์„œ SQL Server Agent๋ฅผ ์„ค์ •ํ•˜๋Š” ๊ณผ์ •์—์„œ ์˜ˆ์ƒ์น˜ ๋ชปํ•œ "๊ถŒํ•œ"์ด์Šˆ๋ฅผ ๋งŒ๋‚ฌ๋‹ค..ํŠนํžˆ, DCOM ๊ตฌ์„ฑ ๋ฐ ๋ ˆ์ง€์ŠคํŠธ๋ฆฌ ๊ถŒํ•œ์ด ํ•ต์‹ฌ ๋ฌธ์ œ์˜€๋‹ค.๐Ÿ“‚ ๋ชฉ์ฐจ 1. ์‚ฌ์šฉ ์ค‘์ธ SQL Server ๋ฒ„์ „ ํ™•์ธSSMS์—์„œ ์ƒˆ ์ฟผ๋ฆฌ ์ฐฝ ์—ด๊ณ  ์•„๋ž˜ ์ž…๋ ฅ:Express Edition์˜ ๊ฒฝ์šฐ์—๋Š” Agent ์‚ฌ์šฉ๋ถˆ๊ฐ€ !!-- ์‚ฌ์šฉ์ค‘์ธ SQL Server ๋ฒ„์ „ ํ™•์ธSELECT @@VERSION; ๋ฒ„์ „ ๊ฒฐ๊ณผ ์˜ˆ์‹œ์„ค๋ช…Microsoft SQL Server Express EditionโŒ Agent ์‚ฌ์šฉ๋ถˆ๊ฐ€ (๊ธฐ๋ณธ์ ์œผ๋กœ ๋น„ํ™œ์„ฑํ™”๋จ)Microsoft SAL Server Standard, ..

DB 2025.07.18