SQL Server Tlhokomeliso Fana ka Boitsebiso ba Phoso ea Round-the-Clock
SQL Server Agent e fana ka tsebiso e ikemetseng ea basebelisi ba databases ha maemo a sa tloaelehang a etsahala. Mokhoa ona o matla oa ho ba hlokolosi o nolofalletsa ho hlahloba lihora tse 24 tsa mosebetsi oa basebetsi ntle le ho sebetsa basebeletsi ba ts'ebetso ea lihora tse 24.
Tlhoko e akaretsang bakeng sa Ho hlalosa Temohelo
E le hore u hlalose tlhokomeliso, u hloka boitsebiso bo itseng ba motheo bo akarelletsang:
- Lebitso la tlhokomeliso - Letsoho la mabitso le tlameha ho ba le ikhethang ho SQL Server. Ha li khone ho feta litlhaku tse 128.
- Ketsahalo e etsang hore e be seli - Mofuta oa ketsahalo o beha mehato e sebelisoang. Mefuta e meraro ea litlhokomeliso ke liketsahalo tsa SQL Server, maemo a ts'ebetso ea SQL Server le liketsahalo tsa Windows Management Instrumentation.
- Ketso eo SQL Server Agent e e nkang ha ketsahalo e qala. Tlhokomeliso leha e le efe e ka abeloa (kapa ka bobeli) ea mefuta ena e 'meli ea tlhokomeliso: Etsa mosebetsi oa SQL Server Agent le / kapa Tsebisa motho ea sebetsang.
Kemiso ea Khato ea Tlhokomeliso ea SQL Server
Litaelo tsena li sebetsa ho SQL Server 2005 le ho feta.
- Bula SQL Server Management Studio mme u ikopanye le seva sa hau ea marang-rang moo u batlang ho hlahisa tlhokomeliso.
- Hlakola fensetere ea Agente ea SQL Server ka ho tobetsa hang ka setšoantšo " + " ho ea ka letsohong le letšehali la folda.
- Tobetsa ka ho le letona Foleng ea Alerts 'me u khethe Alert e Ncha ho tswa ho menu ea pop-up.
- Ngola lebitso le hlalosang bakeng sa temoso ea hau ka Lebitso la lebokose le reng.
- Khetha mofuta oa tlhokomeliso ho tswa ho menu e theoha. Liqeto tsa hau ke maemo a ts'ebetso ea SQL Server joaloka CPU mocheso le sebaka sa disk sa mahala, liketsahalo tsa SQL Server tse kang liphoso tse bolaeang, liphoso tsa syntax le mathata a lihlahisoa, le liketsahalo tsa Windows Management Instrumentation (WMI).
- Fana ka lintlha tse hlakileng tse hlalositsoeng ke SQL Server tse kang litemana tse tobileng tse kenyelletsoeng tlalehong ea ketsahalo le mekhahlelo ea likarolo tsa boemo bo sebetsang.
- Tobetsa konopo ea Likarabo fensetereng e Ncha ea Alert ea Khetha leqephe la holimo .
- Haeba o batla ho phethisa mosebetsi oa SQL Server Agent ha tlhokomeliso e etsahala, tobetsa mosebetsi oa ho hlahloba mosebetsi oa Execute mme o khethe mosebetsi ho tswa ho menu e theoha.
- Haeba o batla ho tsebisa basebelisi ba ditshwantsho ha boitsebiso bo etsahala, tobetsa lebokose la boitsebiso ba ho tseba ho tsebahatsa 'me u khethe basebelisi le mefuta ea tsebiso ho tloha ho grid.
- Tobetsa OK ho hlahisa tlhokomeliso.
Ho eketsa litlhokomeliso Ho sebelisa Transact-SQL
Ho qala ka SQL Server 2008, o ka boela oa eketsa litlhokomeliso ho sebelisa Transact-SQL. Sebelisa syntax ena ho Microsoft:
sp_add_alert [@message_id =] message_id] [, [@severity =] boima], [@ [@enabled =] matlafatsoa],, @ @ @mail_message =] ', [@delay_between_responses =] delay_between_responses] [, [@notification_message =]' notification_message '] [, [@include_event_description_in =] include_event_description_in] [, [@database_name =]' database '] [, [@event_description_keyword =]' event_description_keyword_pattern '] [, {[@job_id =] job_id | [@job_name =] 'job_name'}] [, [@raise_snmp_trap =] phahamisa_snmp_trap] [, [@performance_condition =] 'performance_condition'] [, [@category_name =] 'category'] [, [@wmi_namespace =] 'wmi_namespace '] [, [@wmi_query =]' wmi_query ']