SQL Server Jobs 建立時,發生的錯誤訊息
不知道大家在進立 SQL Server 作業排程時,有無發生以下訊息
我是使用 SQL Server 2005 內建的維護計劃建立排程,完成後發生如上圖的錯誤。另外,我去找對應的工作排程中的步驟與排程,都沒有正確的資料建立
我後來想想,應該是 SSIS 服務並沒有安裝起來。
原因很簡單,雖然維護計劃最後是透過 Jobs 來執行,但是執行步驟裡的定義,其實是由維護計劃精靈去產生一個 SSIS 再交由作業進行執行的,下圖是建立完畢後的圖片:
但是話說回來,SQL Server 在規劃部署的時候,一定要想清楚會用什麼功能。裝太多會影響伺服器效能,裝太少有些功能又無法正常 work,所以囉,一定要想清楚才行。
留言與評論
Thank you a bunch for sharing this with all people you really understand what you are talking approximately! Bookmarked. Kindly also seek advice from my web site =). We could have a hyperlink alternate arrangement among us!
SEOwww.quickieseo.com
SEO DoncasterIts like you read my mind! You appear to know so much about this, like you wrote the book in it or something. I think that you can do with some pics to drive the message home a bit, but instead of that, this is wonderful blog. A great read. I'll definitely be back.
Search Engine MarketingGood day! I know this is kinda off topic but I was wondering which blog platform are you using for this site? I'm getting sick and tired of Wordpress because I've had problems with hackers and I'm looking at options for another platform. I would be great if you could point me in the direction of a good platform.
Cool blogs of 2013I’ll immediately grab your rss as I can not find your e-mail subscription link or e-newsletter service. Do you've any? Please let me know so that I could subscribe. Thanks.
Tom ClaytonHowdy would you mind stating which blog platform you're using? I'm planning to start my own blog in the near future but I'm having a difficult time choosing between BlogEngine/Wordpress/B2evolution and Drupal. The reason I ask is because your design and style seems different then most blogs and I'm looking for something completely unique. P.S Apologies for being off-topic but I had to ask!
Hi BloggersHey There. I found your weblog the usage of msn. That is a really neatly written article. I will be sure to bookmark it and return to read extra of your helpful info. Thanks for the post. I will certainly comeback.
Hi BloggersYou can certainly see your enthusiasm within the paintings you write. The arena hopes for more passionate writers like you who aren't afraid to mention how they believe. At all times follow your heart. "We may pass violets looking for roses. We may pass contentment looking for victory." by Bern Williams.
Dulce Tarver本篇文章的留言功能已關閉!