| 订阅 | 在线投稿
分享
 
 
当前位置: 王朝网络 >> mssql >> jiang jie SQL Server ding shi zuo ye job de she zhi fang fa
 

jiang jie SQL Server ding shi zuo ye job de she zhi fang fa

2008-07-29 06:19:10 编辑來源:互联网 评论
 
本文为【讲解SQL Server定时作业job的设置方法】的拼音翻译版
  ru guo zai SQL Server li xu yao ding shi huo zhe mei ge yi duan shi jian zhi xing mou ge cun chu guo cheng huo 3200 zi fu yi nei de SQL yu ju shi , ke yi yong guan li ->SQL Server dai li -> zuo ye lai shi xian 。
  ◆1、 guan li ->SQL Server dai li -> zuo ye ( an shu biao you jian )-> xin jian zuo ye ->
  ◆2、 xin jian zuo ye shu xing ( chang gui )-> ming cheng [ zi ding yi ben ci zuo ye de ming cheng ]-> qi yong de fang kuang nei shi gou hao ->
  fen lei chu ke xuan ze ye ke yong mo ren de [ wei fen lei ( ben di )]-> suo you zhe mo ren wei deng lu SQL Server yong hu [ ye ke xuan qi ta de deng lu ]->
  miao shu [ tian xie ben ci gong zuo xiang xi miao shu nei rong ];
  [ chuang jian zuo ye fen lei de bu zhou :
  SQL Server dai li -> zuo ye -> you jian xuan suo you ren wu -> tian jia 、 xiu gai 、 shan chu ]
  ◆3、 xin jian zuo ye shu xing ( bu zhou )-> xin jian -> bu zhou ming [ zi ding yi di yi bu zhou ming cheng ]-> lei xing [Transact-SQL(TSQL) jiao ben ]->
  shu ju ku [ yao cao zuo de shu ju ku ]-> ming ling
  [ ru guo shi jian dan de SQL zhi jie xie jin qu ji ke , ye ke yong da kai an niu shu ru yi ge yi xie hao de *.sql wen jian
  ru guo yao zhi xing cun chu guo cheng , tian
  exec p_procedure_name v_parameter1,[ v_parameter2…v_parameterN]
  ]
  -> que ding
  ( ru guo you duo ge bu zhou , ke yi zai ci tiao yong xia mian de xin jian an niu ; ye ke yi dui yi you de duo ge bu zhou cha ru 、 bian ji 、 shan chu );
  ◆4、 jian zuo ye shu xing ( tiao du )-> xin jian tiao du -> ming cheng [ zi ding yi tiao du ming cheng ]-> qi yong de fang kuang nei shi gou hao -> tiao du -> fan fu chu xian ->
  geng gai [ tiao du shi jian biao ]-> que ding
  ( ru guo zhi yao bao cun ci zuo ye , bu yao ding shi zuo ke yi ba qi yong de fang kuang nei shi gou hao qu diao );
  ◆5、 jian zuo ye shu xing ( tong zhi )-> yong mo ren de tong zhi fang fa jiu hao [ dang zuo ye shi bai shi , xie ru Windows ying yong cheng xu xi tong ri zhi ] -> que ding 。
  gen zuo ye zhi xing xiang guan de yi xie SQL Server zhi shi :
  SQLSERVERAGENT fu wu bi xu zheng chang yun xing , qi dong ta de NT deng lu yong hu yao gen qi dong SQL Server shu ju ku de NT deng lu yong hu yi zhi 。
  dian zuo ye you jian ke yi cha kan zuo ye zhi xing de li shi ji lu qing kuang , ye ke yi li ji qi dong zuo ye he ting zhi zuo ye 。
  zui jin zai kan zuo ye li shi ji lu shi , fa xian you de zuo ye ji lu de li shi ji lu duo , you de zuo ye ji lu de ji lu de li shi ji lu shao 。
  ru he neng shi mou xie zuo ye an ge zi de xu qiu , bao liu yi duan shi jian . bi ru bao liu yi ge yue de li shi ji lu .
  kan le SQL Server de zai xian bang zhu wen dang , li mian jie shao shuo :
  zai guan li ->SQL Server dai li -> you jian xuan shu xing -> zuo ye xi tong -> xian zhi zuo ye li shi ji lu ri zhi de da xiao ->
  zuo ye li shi ji lu ri zhi de zui da da xiao ( xing shu ) mo ren wei 1000 ru guo mou tai ji qi de zuo ye shu liang hen duo , yi ding yao ti gao ta , li ru wei 100000
  mei ge zuo ye li shi ji lu ri zhi de zui da xing shu mo ren wei 100 ru guo zuo ye mei tian zhi xing liang ci , xu yao bao liu yi ge yue de ri zhi , ke yi she wei 60。
  ta men zhi jian you yi ge xiang hu zhi yue guan xi , wo men ke yi gen ju zi ji de xu yao lai gai 。
  ru guo SQL Server fu wu qi gai guo ji qi ming , guan li shi jiu ming cheng shi jian li de job de shi hou ke neng hui yu dao
  cuo wu 14274: wu fa tian jia 、 geng xin huo shan chu cong MSX fu wu qi shang fa qi de zuo ye ( huo qi bu zhou huo tiao du )
  kan le Microsoft de wen dang :http://support.microsoft.com/default.aspx?scid=kb;en-us;281642
  shuo SQL Server 2000 xi tong li msdb..sysjobs li originating_server zi duan li cun de shi yuan lai de fu wu qi de ming cheng .
  24X7 zai yong de xi tong ken ding bu neng an shang mian Microsoft de wen dang shuo de na yang ba ming zi gai hui lai you gai guo qu 。
  yu shi xiang ,msdb..sysjobs neng fou update originating_server zi duan cheng xian zai zai yong de xin fu wu qi ming ?
  use msdb
  select * from sysjobs
  zhao dao originating_server zi duan huan shi jiu fu wu qi de job_id, ran hou zhi xing update yu ju :
  update sysjobs set originating_server='new_server_name'
  where job_id='B23BBEBE-A3C1-4874-A4AB-0E2B7CD01E14'
  ( suo ying xiang de xing shu wei 1 xing )
  zhe yang jiu ke yi tian jia 、 geng xin huo shan chu na xie zeng jing chu error 14274 de zuo ye le 。
  ru guo xiang ba zuo ye you yi tai ji qi qian yi dao ling yi tai ji qi , ke yi xian bao liu hao chuang jian zuo ye de jiao ben , ran hou zai ling yi tai ji qi shang yun xing 。
  dao chu suo you zuo ye de chuang jian jiao ben cao zuo bu zhou :
  guan li ->SQL Server dai li -> zuo ye ( shu biao you jian )-> suo you ren wu -> sheng cheng SQL jiao ben -> bao cun dao cao zuo xi tong xia de mou ge sql wen jian
  dao chu mou yi ge zuo ye de chuang jian jiao ben cao zuo bu zhou :
  guan li ->SQL Server dai li -> zuo ye -> xuan zhong dai zhuan yi de zuo ye ( shu biao you jian )-> suo you ren wu -> sheng cheng SQL jiao ben -> bao cun dao OS xia de mou ge sql wen jian
  ran hou zai mu de fu wu qi shang yun xing gang cai bao cun xia lai de chuang jian zuo ye de sql jiao ben 。
  ru guo jian zuo ye de yong hu huo zhe ti xing de yong hu bu cun zai , ze hui chu cuo ;
  wo men xu yao zai mu de fu wu qi shang jian li xiang guan de WINDOWS yong hu huo zhe SQL Server shu ju ku deng lu , ye ke yi xiu gai chuang jian zuo ye de jiao ben , ba mu de fu wu qi shang bu cun zai de yong hu ti huan cheng yi jing you de yong hu 。
  ru guo sheng cheng ri zhi de wu li wen jian mu lu bu cun zai , ye ying gai zuo xiang guan de xiu gai , li ru d:\ qu zhuan f:\ qu deng 。 ling wai , zi fu chuan de @command ming ling li you fen ge fu hao go ye hui chu cuo , ke yi ba ta qu diao 。【原文】【汉音对照
 
 
 
 
 
 
 
 
日版宠物情人插曲《Winding Road》歌词

日版宠物情人2017的插曲,很带节奏感,日语的,女生唱的。 最后听见是在第8集的时候女主手割伤了,然后男主用嘴帮她吸了一下,插曲就出来了。 歌手:Def...

兄弟共妻,我成了他们夜里的美食

老钟家的两个儿子很特别,就是跟其他的人不太一样,魔一般的执着。兄弟俩都到了要结婚的年龄了,不管自家老爹怎么磨破嘴皮子,兄弟俩说不娶就不娶,老父母为兄弟两操碎了心...

如何磨出破洞牛仔裤?牛仔裤怎么剪破洞?

把牛仔裤磨出有线的破洞 1、具体工具就是磨脚石,下面垫一个硬物,然后用磨脚石一直磨一直磨,到把那块磨薄了,用手撕开就好了。出来的洞啊很自然的。需要猫须的话调几...

我就是扫描下图得到了敬业福和爱国福

先来看下敬业福和爱国福 今年春节,支付宝再次推出了“五福红包”活动,表示要“把欠大家的敬业福都还给大家”。 今天该活动正式启动,和去年一样,需要收集“五福”...

冰箱异味产生的原因和臭味去除的方法

有时候我们打开冰箱就会闻到一股异味,冰箱里的这种异味是因为一些物质发出的气味的混合体,闻起来让人恶心。 产生这些异味的主要原因有以下几点。 1、很多人有这种习...

 
 
ru guo zai SQL Server li xu yao ding shi huo zhe mei ge yi duan shi jian zhi xing mou ge cun chu guo cheng huo 3200 zi fu yi nei de SQL yu ju shi , ke yi yong guan li ->SQL Server dai li -> zuo ye lai shi xian 。 ◆1、 guan li ->SQL Server dai li -> zuo ye ( an shu biao you jian )-> xin jian zuo ye -> ◆2、 xin jian zuo ye shu xing ( chang gui )-> ming cheng [ zi ding yi ben ci zuo ye de ming cheng ]-> qi yong de fang kuang nei shi gou hao -> fen lei chu ke xuan ze ye ke yong mo ren de [ wei fen lei ( ben di )]-> suo you zhe mo ren wei deng lu SQL Server yong hu [ ye ke xuan qi ta de deng lu ]-> miao shu [ tian xie ben ci gong zuo xiang xi miao shu nei rong ]; [ chuang jian zuo ye fen lei de bu zhou : SQL Server dai li -> zuo ye -> you jian xuan suo you ren wu -> tian jia 、 xiu gai 、 shan chu ] ◆3、 xin jian zuo ye shu xing ( bu zhou )-> xin jian -> bu zhou ming [ zi ding yi di yi bu zhou ming cheng ]-> lei xing [Transact-SQL(TSQL) jiao ben ]-> shu ju ku [ yao cao zuo de shu ju ku ]-> ming ling [ ru guo shi jian dan de SQL zhi jie xie jin qu ji ke , ye ke yong da kai an niu shu ru yi ge yi xie hao de *.sql wen jian ru guo yao zhi xing cun chu guo cheng , tian exec p_procedure_name v_parameter1,[ v_parameter2…v_parameterN] ] -> que ding ( ru guo you duo ge bu zhou , ke yi zai ci tiao yong xia mian de xin jian an niu ; ye ke yi dui yi you de duo ge bu zhou cha ru 、 bian ji 、 shan chu ); ◆4、 jian zuo ye shu xing ( tiao du )-> xin jian tiao du -> ming cheng [ zi ding yi tiao du ming cheng ]-> qi yong de fang kuang nei shi gou hao -> tiao du -> fan fu chu xian -> geng gai [ tiao du shi jian biao ]-> que ding ( ru guo zhi yao bao cun ci zuo ye , bu yao ding shi zuo ke yi ba qi yong de fang kuang nei shi gou hao qu diao ); ◆5、 jian zuo ye shu xing ( tong zhi )-> yong mo ren de tong zhi fang fa jiu hao [ dang zuo ye shi bai shi , xie ru Windows ying yong cheng xu xi tong ri zhi ] -> que ding 。 gen zuo ye zhi xing xiang guan de yi xie SQL Server zhi shi : SQLSERVERAGENT fu wu bi xu zheng chang yun xing , qi dong ta de NT deng lu yong hu yao gen qi dong SQL Server shu ju ku de NT deng lu yong hu yi zhi 。 dian zuo ye you jian ke yi cha kan zuo ye zhi xing de li shi ji lu qing kuang , ye ke yi li ji qi dong zuo ye he ting zhi zuo ye 。 zui jin zai kan zuo ye li shi ji lu shi , fa xian you de zuo ye ji lu de li shi ji lu duo , you de zuo ye ji lu de ji lu de li shi ji lu shao 。 ru he neng shi mou xie zuo ye an ge zi de xu qiu , bao liu yi duan shi jian . bi ru bao liu yi ge yue de li shi ji lu . kan le SQL Server de zai xian bang zhu wen dang , li mian jie shao shuo : zai guan li ->SQL Server dai li -> you jian xuan shu xing -> zuo ye xi tong -> xian zhi zuo ye li shi ji lu ri zhi de da xiao -> zuo ye li shi ji lu ri zhi de zui da da xiao ( xing shu ) mo ren wei 1000 ru guo mou tai ji qi de zuo ye shu liang hen duo , yi ding yao ti gao ta , li ru wei 100000 mei ge zuo ye li shi ji lu ri zhi de zui da xing shu mo ren wei 100 ru guo zuo ye mei tian zhi xing liang ci , xu yao bao liu yi ge yue de ri zhi , ke yi she wei 60。 ta men zhi jian you yi ge xiang hu zhi yue guan xi , wo men ke yi gen ju zi ji de xu yao lai gai 。 ru guo SQL Server fu wu qi gai guo ji qi ming , guan li shi jiu ming cheng shi jian li de job de shi hou ke neng hui yu dao cuo wu 14274: wu fa tian jia 、 geng xin huo shan chu cong MSX fu wu qi shang fa qi de zuo ye ( huo qi bu zhou huo tiao du ) kan le Microsoft de wen dang :[url=http://support.microsoft.com/default.aspx?scid=kb;en-us;281642]http://support.microsoft.com/default.aspx?scid=kb;en-us;281642[/url] shuo SQL Server 2000 xi tong li msdb..sysjobs li originating_server zi duan li cun de shi yuan lai de fu wu qi de ming cheng . 24X7 zai yong de xi tong ken ding bu neng an shang mian Microsoft de wen dang shuo de na yang ba ming zi gai hui lai you gai guo qu 。 yu shi xiang ,msdb..sysjobs neng fou update originating_server zi duan cheng xian zai zai yong de xin fu wu qi ming ? use msdb select * from sysjobs zhao dao originating_server zi duan huan shi jiu fu wu qi de job_id, ran hou zhi xing update yu ju : update sysjobs set originating_server='new_server_name' where job_id='B23BBEBE-A3C1-4874-A4AB-0E2B7CD01E14' ( suo ying xiang de xing shu wei 1 xing ) zhe yang jiu ke yi tian jia 、 geng xin huo shan chu na xie zeng jing chu error 14274 de zuo ye le 。 ru guo xiang ba zuo ye you yi tai ji qi qian yi dao ling yi tai ji qi , ke yi xian bao liu hao chuang jian zuo ye de jiao ben , ran hou zai ling yi tai ji qi shang yun xing 。 dao chu suo you zuo ye de chuang jian jiao ben cao zuo bu zhou : guan li ->SQL Server dai li -> zuo ye ( shu biao you jian )-> suo you ren wu -> sheng cheng SQL jiao ben -> bao cun dao cao zuo xi tong xia de mou ge sql wen jian dao chu mou yi ge zuo ye de chuang jian jiao ben cao zuo bu zhou : guan li ->SQL Server dai li -> zuo ye -> xuan zhong dai zhuan yi de zuo ye ( shu biao you jian )-> suo you ren wu -> sheng cheng SQL jiao ben -> bao cun dao OS xia de mou ge sql wen jian ran hou zai mu de fu wu qi shang yun xing gang cai bao cun xia lai de chuang jian zuo ye de sql jiao ben 。 ru guo jian zuo ye de yong hu huo zhe ti xing de yong hu bu cun zai , ze hui chu cuo ; wo men xu yao zai mu de fu wu qi shang jian li xiang guan de WINDOWS yong hu huo zhe SQL Server shu ju ku deng lu , ye ke yi xiu gai chuang jian zuo ye de jiao ben , ba mu de fu wu qi shang bu cun zai de yong hu ti huan cheng yi jing you de yong hu 。 ru guo sheng cheng ri zhi de wu li wen jian mu lu bu cun zai , ye ying gai zuo xiang guan de xiu gai , li ru d:\ qu zhuan f:\ qu deng 。 ling wai , zi fu chuan de @command ming ling li you fen ge fu hao go ye hui chu cuo , ke yi ba ta qu diao 。
󰈣󰈤
  免责声明:本文仅代表作者个人观点,与王朝网络无关。王朝网络登载此文出于传递更多信息之目的,并不意味着赞同其观点或证实其描述,其原创性以及文中陈述文字和内容未经本站证实,对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺,请读者仅作参考,并请自行核实相关内容。
 
 
越来越漂亮的楚楚(7)
越来越漂亮的楚楚(6)
越来越漂亮的楚楚(5)
越来越漂亮的楚楚(4)
共长一色
水中莲
峰林晚照
远离喧嚣——山村小景
 
>>返回首页<<
 为你推荐
 
 
 转载本文
 UBB代码 HTML代码
复制到剪贴板...
 
 热帖排行
 
 
 
 
©2005- 王朝网络 版权所有