SQL Server Agent Jobs – Displaying Status in an Application

This article shows ways of getting feedback to your users when running a SQL Server agent job from an ASP.NET page

Generate SQL Agent Job Schedule Report

I am trying to come up with a list of Job Schedules so I can make sure that my Jobs are staggered. Is there a way to query the system tables so I do not have to manually keep track of the schedules?

Display Job Schedule Description (SQL Server 2005)

The idea was taken from this script: http://qa.sqlservercentral.com/scripts/Maintenance+and+Management/61448/

Which did not work in SQL 2005 due to table changes on MSDB

RE: Specified SQL Server not found

Hi, Steve, I have very similar question. I have installed Visio Studio.net and SQL Server 2000 on Windows 2003 Server. I'm using mix mode of security for SQL Server. When I launched .net and try to connect to SQL Server, the same error '[DBNETLIB][ConnectionOpen(Connect()).]Specified SQL Server not found.' came out. I then using ODBC to […]

RE: unknown processes

No, it shlould not cause any problem if you kill them. EXECUTE msdb.dbo.sp_sqlagent_refresh_job @job_id = 0x9E5DC001F44D884EA91544E3087A3F99 is simply a client refreshing a job. The SQLagent_get_perf_counter is a client, local or otherwise, attempting to collect WinNT performance statistics.

RE: Do you think education matters?

Robert, thanks for the input. To read your skills on a resume' (based on the skills you mentioned), would indicate that you have incentive to learn and continuosly improve in your area of expertise. That is a key indicator. The lack of those skills, with a resume' that indicates experience only, would be a bit […]

RE: Clustered SQL Server backup & local drives

Keep in mind that the question was on why can't Enterprise Manager see the local drives. Brian Knight bknight@sqlservercentral.com http://qa.sqlservercentral.com/columnists/bknight

RE: DBAs versus SQL Server

Crappy, keep on writing reports, explaining the problems, estimates, if not getting your heads of the sand scenario I have warned you, disk full, lost data, cost to resolve. How to resolve and costs. Tell users to speak to the manager. Maybe send report to boss's boss.

RE: Full text in Cluster

Verify that the Microsoft Search service is running under the LocalSystem context as well on both nodes. Is this an active/passive or active/active cluster? K. Brian Kelley http://www.truthsolutions.com/ Author: Start to Finish Guide to SQL Server Performance Monitoring http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1