Report overlapping jobs
This script reports jobs which are running when another job is also running. This could be a reason for performance degradations.
2016-07-29 (first published: 2014-06-21)
2,370 reads
schedule
Find the Currently Running Scheduled Job
Ever need to automatically stop a long running job? Ever need to find which named Schedule is the currently running version of your job? There's simple code that'll let you find out.
2013-04-25
5,512 reads
2015-08-07 (first published: 2012-06-20)
15,631 reads
SQL Server Agent Schedule Decoder
This script will break job schedules down into a readable format (msdb.dbo.sysschedules)
2010-01-06 (first published: 2009-12-16)
1,922 reads
TSQL Debugger from a workstation
Trying to use the TSQL debugger in Query Analyzer on a workstation on the local LAN.Environment: SQL 2000 under W2K Server and the WS is XP/ProIf I log into the server under my user account, the TSQL Debugger works properly. However if I attempt to run the debugger from my workstation, same user account I […]
2004-04-21
2004-01-27
RE: Review of MySQL/PHP Database Applications
quote: I haven't found a good MySQL book. At least from the DBA perspective, but it has a number of interesting abilities. I think Paul DuBois wrote the technical reference on MySQL4. Have you tried this? Maybe more interesting than MySQL in terms of a 'grown-up' RDBMS is MaxDB the former SAP DB, which is […]
2003-12-29
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 […]
2003-07-30
RE: clustered index or not
I would definently bring this to their attention. Seems like a waste if they don't help you with their solution or take your findings into account. Otherwise sounds like a real pickle.
2003-07-11
1 reads
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.
2003-07-10
1 reads
Blogs
Small Data SF 2024
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
A New Word: Moledro
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
Snowflake + Azure blob
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers