sql server agentÎÊÌâ
Äܹ»ÔÚservices.mscÖп´µ½sql server agentÒѾÆô¶¯£¬µ«ÔÚmanagement studioÖÐȴûÓÐÏÔʾ£¬²»Ã÷°×ÕâÊÇΪʲô£¿£¿£¿
ÒªÔõôÏÔʾ??²»¶®Ê²Ã´Òâ˼ Èç¹ûûÓÐÏÔʾ,¾Í¿´²»ÁËÏÂÃæÓжàÉÙjob. Ó¦¸ÃÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐÓÐsql server agentÄÇÒ»Ïî¡£ÒýÓà SQL codeSELECT*from MSDB..sysjobservers ²éÒ»Ï塃 jobÔËÐкÃÏñͦÕý³£µÄ¡£ ²»·ÁÈ¥¡°´°ÄÚÍø¡±ÉÏ¿´¿´¡£ ½â¾ö£¬½áÌù¡£
Ïà¹ØÎÊ´ð£º
sql 2005Êý¾Ý¿âÎÒÏëµÃµ½Ò»×Ö·û´®Îª: sldkf|||sdeww erkv|||rltdk jemcl|||ligf ¾ÍÊÇ|||ºóÃæµÄ×Ö·ûÓÐʲôº¯ÊýÄܵõ½Âð£¿ÊÇÔÚsqlÓï¾äдµÄ£¬²»ÊÇÔÚÒ³ÃæÐ´µÄ£¬ÄÇλ¸ßÊÖÀ´Ö¸½ÌÏ£¬ÐÂÊÖ£¬Ð»Ð» ÔÎ µ ......
ÎÒÒª×öÒ»¸ö¶¨µãʼþ£¬ÊÇÿÌìÍíÉÏ12µã¾Í°ÑÈý¸ö±íÀïµÄÐÅÏ¢·ÅÈëÒ»¸ö±íÀÎÒÏëÓô洢¹ý³ÌÀ´Ð´£¬ÔõÃ´Ð´ÄØ£¿£¬ÄÇλ¸ßÊÖ°ï°ïæ°É£¬·Ç³£¸Ðл£¡ Óû§ÃûÊÇΨһµÄ ±íA ×Ö¶Î Óû§Ãû£ºName ,ÓÊÏ䣺Ema ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......