Question : I have a Windows 2012 RS and SQL Server 2012 Enterprise Edition. I have SQL Server maintenance jobs […]
Tag: sql-server-agent
SQL Agent stopped recording history (SQL Server 2017)
Question : I have a Dev server that has been running without issue for at least 2 years. This dev […]
Need to setup a sql alert on “waiting tasks” – similar to “waiting tasks” in Activity Monitor
Question : My manager has asked me to work upon a request. I am not sure if it is reasonable […]
Query job history for TSX servers from MSX server using TSQL
Question : I am attempting to construct TSQL queries to substitute various GUI tools provided by SQL Server Management Studio. […]
SQL Job Fails Logging In to Integration Services
Question : I have a SQL Server 2012 where all databases are set up in instances. I created a DTS […]
Does SQL Server 2014 Express, with Advanced Services, actually support full text search?
Question : I’ve installed SQL Server 2014 Express edition, with advanced services. I was hoping to try out the full-text […]
How to query Job Activity Monitor to get a list of all jobs
Question : I am trying to obtain a list of ALL jobs (SQL Agent jobs). Specifically, I am trying to […]
How do I pass or fail a job in SQL Server agent based on a return value from a stored procedure?
Question : What do I need to do in order to execute a step in a SQL Server 2012 agent […]
SQL Server 2016 -number of SQL agent replication jobs(transaction log repl)
Question : So I have a SQL server 2016 on a Windows Server 2012 instance. We have 140 databases(small to […]
Query to check if job already belongs to jobserver in MSSQL
Question : I am working with a legacy migration script that was setup to add a job (With a number […]