Skip to content
DbaFix
Just share answer and question for fixing database problem
MENU
  • HOME

Tag: sql-server-agent

SQL Agent Proxy – writing to logs is only allowed to jobs that are owned by sysadmin

By adminPosted on January 29, 2023

Question : I have a Windows 2012 RS and SQL Server 2012 Enterprise Edition. I have SQL Server maintenance jobs […]

SQL Agent stopped recording history (SQL Server 2017)

By adminPosted on January 27, 2023

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

By adminPosted on January 26, 2023

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

By adminPosted on January 24, 2023

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

By adminPosted on January 22, 2023

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?

By adminPosted on January 15, 2023

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

By adminPosted on January 11, 2023

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?

By adminPosted on January 8, 2023

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)

By adminPosted on January 6, 2023

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

By adminPosted on January 3, 2023

Question : I am working with a legacy migration script that was setup to add a job (With a number […]

  • 1
  • 2
  • 3
  • …
  • 24

Recent Posts

  • Restored database copy larger than original
  • SQL Server Failed Login – SQL Server login (not windows) – Random times
  • Steps or evaluation order of the SQL statement
  • Can I kill these MSCRM related SQL processes?
  • Postgres to Postgres DBLink with AWS/RDS
  • What are the pros and cons of having more data-bearing members in a MongoDB replica set? [closed]
  • Transaction log backup after full backup is too big
  • Strange behavior with Quotename and substring [closed]
  • MySQL slow select from a view
  • CREATE INDEX vs ALTER TABLE ADD INDEX – MySQLism, or SQL Standard?
  • How to run my query on a one-to-many relation to run efficiently
  • Can I get SSMS to show me the Actual query costs in the Execution plan pane?
  • What are the best Database Analytics Companies for analyzing several 1000s or Mio. of products,sum them together and analyze them for statistics?
  • How to list the permissions on User-Defined Table Types?
  • Do I need an auto-generated ID in addition to a unique field?
  • Why should foreign keys be implemented in my relational database? [duplicate]
  • Difference between changed compatibility level database and new database
  • Does a query with a primary key and foreign keys run faster than a query with just primary keys?
  • What is the limit on the number of INSERT statements you can paste into SSMS and run?
  • String or separate Table

Categories

  • Database Backup
  • Database Design
  • Database Index
  • Database Optimization
  • InnoDB
  • Join
  • MariaDB
  • MongoDB
  • MySQL
  • Oracle
  • Performance
  • Permissions
  • Postgresql
  • Query Performance
  • Replication
  • Security
  • SQL Server
Proudly powered by WordPress / Support by: DizzyCoding