Sarrafa Cibiyar Gudanarwa tare da Ma'aikatar SQL Server

01 na 06

Fara sabis ɗin Agent na SQL Server

Ma'aikaci na SQL Server ya ba ka izinin ayyukan sarrafawa da dama. Ɗaya daga cikin waɗannan ayyuka ya shafi yin amfani da SQL Server Agent don ƙirƙirar da kuma tsara aikin da cewa automates database administration.

Bude Microsoft SQL Server Kanfigareshan Manager kuma gano wuri da SQL Server Agent sabis. Idan matsayin wannan sabis ɗin "RUNNING," ba buƙatar ka yi wani abu ba. In ba haka ba, danna-dama a kan sabis na Agenda na SQL Server kuma zaɓi Fara daga menu na farfadowa don bude Gidan Farawa.

Lura : Wannan labarin ya shafi SQL Server 2008. Idan kana amfani da wani daga baya version of SQL Server, za ka iya so ka karanta Harhadawa SQL Server Agent a cikin SQL Server 2012 .

02 na 06

Bude SQL Server Management Studio da kuma Expand da SQL Server Agent Jaka

Rufe Gudanarwar Kasuwancin SQL Server kuma bude SQL Server Management Studio. A cikin SSMS, fadada babban fayil na SQL Server.

03 na 06

Ƙirƙirar sababbin sababbin ayyukan SQL Server

Danna-dama a babban fayil ɗin Ayyukan kuma zaɓi Sabon Ayuba daga menu na farawa. Cika cikin filin Sunan tare da suna na musamman don aikinku (zama mai kwatanta zai taimake ku sarrafa ayyukan aiki mafi kyau a ƙasa). Saka asusun da kake son kasancewa mai aiki a cikin akwatin rubutu mai mallakar . Ayyukan za su gudana tare da izini na wannan asusun kuma za'a iya canzawa ta mai shi ko membobin membobin sysadmin.

Bayan ka saka sunan da mai shi, zaɓi ɗaya daga cikin ayyukan da aka riga aka zaɓa daga lissafin da aka sauke. Alal misali, za ka iya zaɓar ma'anar "Ɗaukin Bayanan Bayanan" don ayyukan aikin kulawa na yau da kullum.

Yi amfani da babban filin rubutun Magana don samar da cikakkun bayanai game da dalilin aikin. Rubuta shi a hanyar da wani (wanda ya hada da ku) zai iya duban shi shekaru da yawa daga yanzu kuma ku fahimci manufar aikin.

A karshe, tabbatar da cewa An sanya akwatin An kunna .

04 na 06

Shigar da Sakon SQL Server Ayyukan Ayuba

A gefen hagu na sabon Sabuwar Ayuba window, za ku ga gunkin mataki a ƙarƙashin "Zaɓi shafin". Danna wannan gunkin don ganin blank Aikin Mataki na Mataki.

05 na 06

Ƙara Sakon SQL Server Aikin Matakai

Ƙara kowane mataki don aikin. Danna maɓallin New don ƙirƙirar sabbin matakan aiki kuma za ku ga sabon aikin mataki na New Job.

Yi amfani da akwatin rubutun Mataki don samar da sunan fasali don Mataki.

Yi amfani da akwatin da aka saukar da Database don zaɓin bayanan da aikin zai yi.

A karshe, yi amfani da akwatin rubutun Dokokin don samar da haɗin Transact-SQL daidai da aikin da ake so don wannan aikin. Bayan ka gama shigar da umurnin, danna maɓallin Parse don tabbatar da haɗin.

Bayan an samu nasarar tabbatar da haɗin ɗin, danna Ya yi don ƙirƙirar mataki. Maimaita wannan tsari sau da yawa kamar yadda ya cancanta don ayyana aikin da ake bukata na SQL Server Agent.

06 na 06

Jadawalin aikin SQL Server Aikin Ayuba

Ka shirya jadawalin aikin ta danna maɓallin Jaddadawa a cikin Zaɓi wani ɓangaren Page na sabon Sabuwar Aiki . Za ku ga Sabuwar Aikin Tsara Ayyuka .

Samar da wani suna don jadawalin a cikin akwatin rubutu na Rubutun kuma zaɓi nau'in tsarin jadawali-Ɗaya-lokaci, Sauyawa, Fara lokacin da Agenda na SQL Server ya fara ko fara Lokacin da CPUs Ya zama Guda-daga akwatin da aka sauke. Yi amfani da ɓangaren ƙayyadaddun lokaci da kuma tsawon lokaci na window don tantance sigogi na aikin. Lokacin da ka gama, danna Ya yi don rufe Tsarin jigilarwa kuma Yayi don ƙirƙirar aikin.