The maximum job history log size defaults to 1000 if the number of jobs a machine a lot, we must improve it, such as job history log for each 100,000 maximum number of rows default to 100 if the job executed twice a day, need to retain months log, can be set to 60 mutual restraint between them have a relationship, we can change according to their own needs. If the SQL Server server to turn the machine name, and management is created when the old name of the job may encounter an error when 14274: Can not add, update, or delete from the MSX server-initiated operations Read the Microsoft document: http://support.microsoft.com/default.aspx?scid=kb; en-us; 281642 SQL Server 2000 system that msdb .. sysjobs in originating_server field is stored in the original server name.
The deal highlights the popularity of Microsofts Linux and open source business model to accept. Analysts said the two companies plan to achieve technical interoperability for the integrated use of Microsoft and Novell hope that users of the software attractive. Patent agreements, including Mono and Samba. The two companies also announced that it will improve the Windows Server and Suse Enterprise Linux management. Financial analysts said that despite the very wide scope of cooperation, but its effect is not substantial for Microsofts. Goldman Sachs analyst Rick in a report on Friday that the agreement for the two companies to provide a huge marketing advantage. Customers will therefore benefit, taking into account the lower market share Suse Linux, Novell also has been marketing its much-needed impetus. And Microsoft just got a willingness to cooperate with the open source community a good impression.