ÇóÖú:QuartzÈçºÎʵÏÖÀàËÆMs sqlserverµÄµ÷¶È?
ÈçºÎÓÃQuartzʵÏÖÈçϵĵ÷¶ÈÄØ?
SqlServerµÄ×÷Òµµ÷¶ÈÊDZȽÏÈ«ÃæµÄ.×ܽáÆðÀ´ÈçÏÂ:
1. ´Ó2010-2-1ÈÕ¿ªÊ¼Ò»Ö±Ö´ÐÐ,ÿ¸ô3ÌìÖ´ÐÐÒ»´Î,ÔÚ9:30:00Ö´ÐÐ.
2. ÔÚ2010-2-1ÖÁ2010-12-20Ö®¼ä,ÿ¸ô4ÌìÖ´ÐÐ,µ±ÌìÄÚ´Ó9:00:00ÖÁ20:00:00ÿ¸ô2СʱִÐÐÒ»´Î.
3. ÔÚ2010-2-1ÖÁ2010-12-20Ö®¼ä,ÿ¸ô2ÖܺóÔÚÖÜÒ»/Öܶþ/ÖÜËÄÖ´ÐÐÒ»´Î,ÔÚ10µãÖ´ÐÐ.
4. ÔÚ2010-2-1ÖÁ2010-12-20Ö®¼ä,ÿ¸ô2ÖܺóÔÚÖÜÁù/ÖÜÈÕ¸÷Ö´ÐÐ,Ö´Ðе±Ìì´Ó9:00:00ÖÁ20:00:00ÿ¸ô2СʱִÐÐÒ»´Î.
5. ÔÚ2010-2-1ÖÁ2010-12-20Ö®¼ä,ÿ¸ô2ÔºóÔÚ3ºÅÖ´ÐÐ,Ö´Ðе±Ìì´Ó9:00:00ÖÁ20:00:00ÿ¸ô2СʱִÐÐÒ»´Î.
6. ÔÚ2010-2-1ÖÁ2010-12-20Ö®¼ä,ÿ¸ô2ÔºóÔÚµÚ2¸öÖÜÎåÖ´ÐÐ,Ö´Ðе±Ìì´Ó9:00:00ÖÁ20:00:00ÿ¸ô2СʱִÐÐÒ»´Î.
ÎÒÖ»ÊÇÖªµÀÿ¸ôNÌì <ÖÜ/ÔÂ>Ö´ÐÐÒ»´ÎµÄд·¨ÓÃsimpleTrigger¾ÍÐÐ.
¾ßÌåijÌìµÄijµãÖ´ÐÐÄØ,¿ÉÒÔÓÃcronTrigger.
µ«ÏñÕâÖÖ,ÿ¸ôNÌìÖ´ÐÐ,ÇÒµ±ÈÕÄÚ»¹Ñ»·Ö´ÐеÄǶÌ×ÀàÐÍ.ÎÒ»¹Õæ²»ÖªµÀÔõôŪ.
¸÷λ´óϺ°ïÖú°¡.ллÁË.
¹ýÄêÁË.Ïȸø¸÷λÌáǰ°ÝÄêÀ².
ºÃÏñҪʹÓöà¸ö <cron>ÁË¡£¡£
²»ÖªµÀզд£¬ÏȰïÄã¶¥ÏÂ
¶à¸öcron??»¹ÕæÃ»Åª¹ý.
ÏëÏë....
Èç¶Ô2À´Ëµ:
2. ÔÚ2010-2-1ÖÁ2010-12-20Ö®¼ä,ÿ¸ô4ÌìÖ´ÐÐ,µ±ÌìÄÚ´Ó9:00:00ÖÁ20:00:00ÿ¸ô2СʱִÐÐÒ»´Î.
Ūһ¸öÿ¸ô4ÌìÖ´ÐеÄSimpleTrigger,°ó¶¨µ½Ò»¸öJobAÉÏ.JobAµÄ¹¤×÷ÊÇÆô¶¯ÁíÒ»¸öJobB,¸øJobB¸³ÖµÉÏÒ»¸öTriggerÊÇJobAÖ´ÐÐÈÕµ±ÌìÄÚ,´Ó9µãµ½20µãÖ®ÄÚÿ¸ô2Сʱѻ·Ö´ÐÐ...
Ã²ËÆ¿ÉÒÔѽ???ÎÒ×Ðϸ×ÁÄ¥×ÁÄ¥...
Cron±í´ïʽʱ¼ä×Ö¶Î
λÖà ʱ¼äÓòÃû ÔÊÐíÖµ ÔÊÐíµÄÌØÊâ×Ö·û
1 Ãë 0-59 , - * /
2 ·ÖÖÓ 0-59 ,
Ïà¹ØÎÊ´ð£º
ÓÐÈËÊÔ¹ýÔÚwin7Éϰ²×°sqlserverÂð£¿
Ìý˵sql2000×°²»ÉÏÈ¥£¬²»ÖªµÀÆäËû°æ±¾Ðв»ÐС£
ºÃÏñ²»ÐÐ,²»¼æÈÝ,ÉÏ´ÎÒ²ÓÐÈËÎʹýѽ
ºÇºÇ£¬ÓÐÍøÓÑÓÐÏà¹ØµÄ¾ÑéÂð£¿
Õâ¸ösqlserverÒª¾¡Á¿×°ÔÚwin7ÉÏ¡£
SQLSERVER 2000Ã ......
sqlserverÖж¨Òå×Ö¶Îʱ£¬ÓбêʶÖÖ×Ó¡¢±êʶºÍ¹«Ê½µÈ£¬ÊÇʲôÒâ˼£¿
Ó¦¸Ã˵µÄÊÇidentity°É
identity?ɶÒâ˼£¿
IDENTITY£¨º¯Êý£©
Ö»ÓÃÔÚ´øÓÐ INTO table ×Ó¾äµÄ SELECT Óï¾äÖУ¬ÒÔ½«±êʶÁвåÈ뵽бíÖС£
¾¡¹ ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬
sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º
ÈÕÆÚ 2010-1-25 14:45: ......
ÏÖÔÚÓÉÓÚÐÂÊÖÎó²Ù×÷£¬ÏÖÔÚֻʣÏÂÈÕÖ¾ÎļþÁË£¬ÇëÎʸßÊÖÄܲ»Äָܻ´£¬Ð»Ð»£¡
SQL code:
ÊDz»ÊÇÍêÕû»Ö¸´Ä£Ê½??
ʹÓÃLog Explorer²é¿´ºÍ»Ö¸´Êý¾Ý
Log Explorer 4.1.¿ÉÓÃÓÚSQL Server2005µÄÈÕÖ¾²é¿´¹¤¾ß
ÏÂÔØµØÖ·:
......