Monitoring Jobs Across Servers/versions

Jan 30, 2008

Hi all,
I've been digging around the last few days, looking for the best way to monitor all the jobs on all my prod servers. Using EM or SSMS is BS. I've been thinking that perhaps the best strategy is to write or modify a script that gathers information from sysjobs and sysjobhistory on all servers and then inserts it into my main DBA database on my "admin" server. Of course this script would have to be on all servers and be in a scheduled job itself. I'm thinking that I should probably categorize every job in the company and break out my reports that way too. I'll probably throw all the data into a cube so I can do some at a glance checks to see that everything is running ok. I'd like to trend run times with the data too.

Anyway as with most fun projects there are many different way to accomplish this. I've hit on one above and I've seen several others. What are some of the solutions you guys have come up with, what have you tried that didn't work so well and what are some pitfalls that I should avoid in setting this up?

Cat

View 3 Replies


ADVERTISEMENT

Space Monitoring; Several Servers

Feb 4, 2000

I'd like to find out how people handle monitoring the disk space used and available per database across all of their databases and severs. The information returned in sp_spaceused is what I'm looking for, but it is for one databases only. How is everyone managing many databases on many different severs?

Are there scripts or tools available for this? Has anyone written any vb code using SQL-DMO?

Thank you for your help...

View 1 Replies View Related

Monitoring Failovers On Clustered Servers

Jan 29, 2004

I've been asked to write a script to monitor whether a clustered server is up and alive and if so which node it's actually running on. Apparently there's been some problems of failover to the passive server without anyone knowing that it happened and they want to know. Any suggestions?

View 9 Replies View Related

How To Copy All Jobs Between Sql Servers

Nov 14, 2000

hi, I do have over 30 scheduled jobs in one sql server in which I want to have the same jobs in another sql server. What is the best way to copy those jobs?

I thought of backing up the msdb from one sql server then restoring msdb into another sql server..... someone advice me NOT to do so due to potential compatibility problems that he did not explicitly state.

I am hoping to get the answer here.

Thanks

Ahmed

View 5 Replies View Related

Help!!! Copying Jobs Between Servers

Dec 22, 1999

I have two servers running SQLserver 7.0. I have a number of jobs that are configured to import files from an AS/400 each day. I do not want to recreate these JOBS on the second server, for it took quite sometime to set up only one. I know that I can set up multi server jobs, but I want these jobs to run independant of the Master server. In other words I just want to move a copy of the job over to the next server.

View 1 Replies View Related

All Maintenance Jobs On New Servers Failing

Sep 2, 2002

Hi all,

I've just set up 2 new SQL 7.0 servers, and my new maintenance jobs - backups, optimisations, consistency check jobs etc - are all mysteriously failing. I've created them both with the Maintenance Wizard, and again by hand. I've attempted manual and scheduled runs. All to no avail. Nor do they populate the sysmainthistory table, although they're configured to do so. The mystery is that we have successfully installed some user DTS processes, and THEIR jobs work. In order to resolve the problem, I've:

(1) ensured the Agent service is running;

(2) ensured adequate space on the drive etc;

(3) verified that sqlmaint.exe exists in Mssqlinn;

(4) unchecked the 'attempt to repair minor errors' box (I read this was a known cause of the problem);

I've got some clues to go on, but nothing conclusive;

'sqlmaint.exe failed. [SQLSTATE 42000] (Error 22029). The step failed.'

Executed as user: NT AUTHORITYSYSTEM. sqlmaint.exe
failed. [SQLSTATE 42000] (Error 22029). The step
failed.

Additionally, both servers hold databases that I imported from another server-INCLUDING the msdb, and BOTH have the same problems and same error messages. This cannot be a coincidence.


Anyone have any ideas?


Thanks in advance,


JB.

View 1 Replies View Related

Easiest Way To Recreate Jobs Between Servers

Aug 27, 1999

Hi!

What is the easiest way to recreate jobs running on one server on another server?

Thank you

Praveena

View 2 Replies View Related

How-To Copy SQL Agent Jobs Between Servers

Oct 20, 2005

I need to move SQL Agent scheduled jobs from one server to another..

Here are the details:

Source Server
SQL 2000 SP3 (upgraded from SQL 7)
Data stored in MsSQL7Data

target
SQL Server 2000 SP4
Data Stored in DATA

DTS Packages have already been resaved on Target Server, how can I copy the scheduled jobs over?

Thanks

View 2 Replies View Related

DB Engine :: Agent Jobs Status For Multiple Servers Using Powershell?

Oct 14, 2014

I am following website link:

[URL]

I require to gather status details about all the SQL Agent jobs in the environment on multiple SQL Servers.

I tried to edit the script using:

[void][System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO")
$sqlServerName = 'localhostdeveloper'
 $sqlServer = New-Object Microsoft.SqlServer.Management.Smo.Server($sqlServerName)
 foreach($job in $sqlServer.JobServer.Jobs)
{
$job | select Name, OwnerLoginName, IsEnabled, LastRunDate, LastRunOutcome, DateCReated, DateLastModified
}

but SQL Agent jobs are not reflecting in the mail output...

View 11 Replies View Related

SQL 2012 :: Monitoring Tool Using Powershell And Performance Monitoring

Sep 15, 2014

We are in plan to build a Monitoring tool using PowerShell and Performance Monitor which could monitor 10 to 20 servers. Do you have any reference of any existing tool using Performance Monitor to monitor the SQL Server and available for free? I didn't want to put some effort, if something is available already.

View 2 Replies View Related

Sql Report Works Fine On Internal Servers - Hosed On External Servers - Need Some Help

Nov 21, 2007

I have a report that was designed using SQL Reporting Services that sits on a SQL reporting server. It's nothing too exciting, it is essentially a three page application with legal jumbo on pages 2 and 3 and applicant data in fields on page 1.

We use rectangles to force page breaks to page 2 and to page 3.

When running the report on the report server, it shows and prints fine.

When running the report from the QA website internally, it shows and prints just fine.

When running the report from the production website from a machine internally, it shows and prints just fine.

When running the report from outside of the company network, the report is jacked. It obliterates large chunks of text, crams text together, and creates blank pages.

I need help in determining where I even begin with trouble shooting this!

View 1 Replies View Related

Development Servers, Auto-update Live Servers

Aug 21, 2001

can anyone tell me if they know of a way to automate the update process from development servers to live server, with little interference from an administrator

I have a development team that are constantly updating their databases along with their ASP code, and want to publish changes an a weekly basis. They have asked me for a way to take their new structures, tables, procedures etc, and copy them to the live servers, but NOT to interfere with existing customer data.

Funny I know – and I hate the idea btw :(

Any references, contacts, 3rd party tool recommendations welcome,

Thanx,

Darren

View 1 Replies View Related

Linking SQL 2005 Servers To SQL 2000 Servers Problems

Sep 27, 2007

I am in the middle of a major migraton project, moving from x86 SQL 2000 to IA64 SQL 2005. I have a business need to link to several legacy servers. I have a number of problems I am trying to solve.

1) Linking a Kerberos server to a non-Kerberos server.
2) Linking x64 or IA64 servers to x86 servers.
3) Linking SQL 2005 to SQL 2000.

Two of the errors I am encountering are:
------------------------------
TCP Provider: An existing connection was forcibly closed by the remote host.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
OLE DB provider "SQLNCLI" for linked server "SCDC250DB" returned message "Communication link failure".
(Microsoft SQL Server, Error: 10054)
------------------------------
And
------------------------------
The OLE DB provider "SQLNCLI" for the linked server "SCDC250DB" reported an error. Authentication failed.
Cannot initialize the data source object of OLE DB provider "SQLNCLI" for linked server "SCDC250DB".
OLE DB provider "SQLCLI" for linked server "SCDC250DB" returned message "Invalid authorization specification".
(Microsoft SQL Server, Error: 7399)

If someone has worked through these problems before, I would appreciate it if you could direct me to the relevant documentation to resolve these issues.

Thanks!


Brandon Forest

Database Administrator

Data & Web Services Team

Sutter Connect Information Technologyforesb@sutterhealth.org

View 2 Replies View Related

Help With Versions

Apr 24, 2001

We are in need of a solution to our problem. We are working for a customer and cannot use their database to work on during development. We have copied the layout and made a sample db for our development.
Rather than writing down all the changes we make to our own db and then making the same changes to the customer's, is there a better way? Can we use something like sourcesafe?
Thankyou

View 1 Replies View Related

SQL Versions

Oct 20, 2004

I've got a few SQL Servers at work which are development servers using SQL Server Standard Edition. I would like to downgrade them to SQL Server Developer Edition to save the Standard Edition licenses for production purposes. However, i do not wish to uninstall and reinstall SQL Server Developer Edition, restore all the dbs. Is there a way to change the version of the SQL Server ?

View 2 Replies View Related

Two Versions On The Same Box

Oct 9, 2007



Hi All,
Can we have 2 versions of SQL Server on the same server? Example, can I install SQL Server 2000 and 2005 on the same server? Please let me know about all the combinations possible/not possible.

Thanks a lot.

Mannu.

View 3 Replies View Related

Updating Need Two Different Versions

Dec 21, 2005

Is there a way to do the following -- I need to be able to update a table based on a selection by a DDL.  So here are my two update queries:
1. Update RequestData Set Approved = True Where DeptID = @DeptID2. Update RequestData Set Approved = True (Yes I need to be able to do all of the rows at once.)
But it's all based on the selection of the DDL---I really don't want to have to create two seperate sql commands any ideas?

View 4 Replies View Related

DTS Package Versions

Mar 22, 2001

Is there a way to remove old versions of a DTS package without rewriting the entire package?
These packages run fine but take up more space than I am willing to allocate.

View 1 Replies View Related

Versions Of SQL For SAN Support

Oct 22, 2001

I understand the SANs are only Supported by SQL Server 2000 Enterprise and no other versions of SQL, can anyone supply information to the contrary please?

View 2 Replies View Related

Multiple Versions

May 12, 2000

Has anyone ever attempted to run 6.5 & 7.0 from the same server?

View 1 Replies View Related

Installing 2 Versions

Mar 4, 1999

This may seem like a wierd question, but can I have 6.5 and 7.0 running on the same machine? I need 6.5 for production builds and 7.0 for test. Is this possible? THanks

Frank

View 1 Replies View Related

Trial Versions Of 7 Still Available?

Nov 15, 2001

I can see that SQL server 2000 trial is available for download, but I need to try out 7 for a particular project at work. Is this available for trial download? (Has it ever been?)

Thanks.

View 2 Replies View Related

Different Versions Of MS SQL Server

Sep 23, 2005

Hi all...
I'm a MySQL user and I want to switch to MS SQL Server, I heared that there is more than one type of MS SQL Server and one or two can be downloaded for free. Can someone tell me the different types of MS SQL Server and where can I download those free versions?

View 5 Replies View Related

Different Versions Of SQL On One Server

Sep 25, 2007

Hi,

Our server has SQL Server 2003 installed, I'd like to use SQL Server Express 2005 as I'm about to try and learn ASP.NET and most tutorials use that.

Will installing Express 2005 conflict with the Server 2003? Can both version be run on one server?

Thanks.

View 3 Replies View Related

Synchronized Versions

Jul 23, 2005

I'm running a SQL 7 db on a LAN in city A with other users accessing it fromanother city (city B) over a WAN. Obviously the WAN users are getting muchslower access to the data. One thing I was wondering was if it was possibleto have two versions of the database, one on each server, and have themautomatically synchronize as users at each location make changes. Or, ifthat's not possible, then at least have the city B users get any changesthat the city A users get as they are made.Thanks for any input.Neil

View 5 Replies View Related

Two Versions Of Sql On One Server?

Oct 25, 2006

Is it possible to run both SQL200 standard and SQL2005 Express on thesame server? I need to test a database created in 2005 on ourproduction server but don't want to upgrade our "live" databases yet.

View 2 Replies View Related

32-64 Bit Versions Issue

Jan 23, 2006

I uninstalled the 32-bit Standard version but during install of the 64-bit trial version I got an error that the integration services could not install because the 32-bit version of COM+ was already registered and you can't have both. Need some help how to resolve this issue. Thanks

View 3 Replies View Related

Conflicting Sql Versions

Jan 17, 2008

I have a server with sql 2000 and 2005 installed on it. When I try to connect to the msde 2000 database with an app or with managment studio express I get the following error

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476"

But When I go through dos and type osql -S(local)database -E
it connects to the correct msde instance. How can I fix this with out uninstalling sql server 2005????

View 3 Replies View Related

.Net Versions Question

Mar 7, 2008

We will be upgrading from SQL 2000 to SQL 2005. From what I have read, as part of the installation of SQL 2005 we will be installing the .Net framework 2.0 and Visual Studio 2005.
We currently have production .Net applications which were developed in Visual Studio 2003 with the .Net framework 1.1.
We plan at some point to upgrade our applications to Visual Basic 2005, but we were planning on upgrading to SQL 2005 first.
I have a couple of questions about this.

1) We are a small shop and the same server which hosts our production applications also hosts SQL server for our model office and test applications. Can we have both versions of the common language runtime running on the same server?

2) Our .Net applications access the SQL data through stored procedures or views. I have run the Upgrade Advisor and it does not look as though there are any signficant upgrade issues with our SQL database objects, so we are tentatively planning on changing the compatibility levels of our databases to 90 after they are imported to SQL 2005. Assuming we take care of any SQL issues that we do have with our database objects, should we expect to encounter problems running our existing applications, under the older version of vb.net, and accessing our databases once we have upgraded to SQL 2005? (Of course we plan to test everything, but I just wanted to know if we should anticipate anything in particular.)

Thanks.

View 6 Replies View Related

SQL Server - Differente Versions

Jan 28, 2008

Hi
If i develop a web application with sql server developement edition, it works fine in my webserver, or my webserver has to have the sql server development too?
I'm interested in sql server report services. if i develop a web application with this tool what kind of version of sql server has to be installed in my webserver?
Thank you

View 2 Replies View Related

DTS & Client Tools Versions

Mar 15, 2001

SQL 2000 Client tools SQL7 SP3 Server back-end.

I have a DTS Package created with SQL2000 client tools, which contains a SQL connection and a sql task (exec sp_who2). When I run the package on my PC it works, when I run the package via SQL Agent it comes back with :-

DTSRun: Loading... Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The system cannot find the file specified. Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts.hlp Help context: 713. Process Exit Code 1. The step failed.

I am not using any files. The DTS Package is called PMC_Test

Here is the dtsrun syntax from the SQL Agent job.

DTSRun /S "APP003" /N "PMC_Test" /E

When I try and open the DTS package using SQL7 client tools I get the same error message.

View 1 Replies View Related

Odbc Dll Versions Don't Match??

May 15, 2001

I'm trying to correct an error that a user is getting when running SQL Server 7.0 SP3, Desktop edition/ Windows NT 4.0 SP6. The error says that C:WINNTSYSTEM32odbcint.dll and C:WINNTSYSTEM32odbccp32.dll are different versions. I tried to install MDAC 2.5 sp1 to correct this problem but this message continues throughout the install. This is causing sqlagent service to hang. Any ideas of how to reinstall ODBC components without reinstalling the OS?

View 1 Replies View Related

DTS & SQL Client Tools Versions

Mar 14, 2001

Does anyone know of problems when using SQL7 Server and SQL2000 Client tools when editing and saving DTS Packages ?

My SQL 7 Server doesn't seem to recognise the DTS Package if saved from SQL 2000 Client tools, but works happily with packages saved from SQL7.

Can anyone clarify ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved