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

Tag: jobs

begin tran instead of use db_name inside a SQL Job for executing Stored Procedure

By adminPosted on January 20, 2023

Question : I was defining a SQL job yesterday for executing stored procedure at a specific time in the morning. […]

Exporting scheduled jobs in Oracle

By adminPosted on January 6, 2023

Question : This is probably very simple but i already exported all but the scheduled jobs i created to subsequent […]

Linked Server Timeout – Not Queried

By adminPosted on January 2, 2023

Question : I have a job that runs for multiple regions across the globe. Depending on what region is running […]

Find jobs and dependencies run between two timestamps

By adminPosted on December 24, 2022

Question : I would like to know what jobs ran and dependencies (what triggered them) between two timestamps or dates. […]

Why can’t user with SQLAgentOperatorRole delete his own SQL jobs

By adminPosted on December 18, 2022

Question : I created a login and a user. I assigned the user as the db owner of the database […]

Need help in getting mysql event scheduled every monday and wednesday

By adminPosted on December 17, 2022

Question : I have coded an event as below to run every Monday and Wednesday, but it runs only on […]

Isssue with Database Links converting OEM Job to DBMS_Scheduler Job

By adminPosted on December 11, 2022

Question : We had an OEM job that would run a PL/SQL block using a particular database users credentials. The […]

Why does this query fail when I run it from a SQL Server job?

By adminPosted on December 8, 2022

Question : I know how to solve the issue, but I don’t understand the technicality of why the below query […]

SQL Server Agent & sp_send_dbmail failing on permissions

By adminPosted on December 3, 2022

Question : I have set up a SQL Server Agent job to call sp_send_dbmail with a very simple select on […]

How can I run a SQL job every 1 second? [duplicate]

By adminPosted on November 23, 2022

Question : This question already has answers here: How to schedule jobs in Sql server 2008 for less than 10 […]

  • 1
  • 2
  • 3
  • …
  • 18

Recent Posts

  • Reasons for avoiding large ID values
  • Sql Statement to display multiple true statement
  • How do I force SQL Server to use my spatial index through a view?
  • How to optimize selection of pairs from one column of the table (self-join)?
  • Unable to drop the table since its showing waiting for meta data lock
  • SQL Server: localhost vs MSSQLLocalDB
  • Exclude rows when a column has matches
  • Converting 3 Master + 1 Slave to 4 Master – Any advice?
  • Creating a test database from Production database (different machines & servers)
  • Wrong results on queries with join for some MariaDB versions
  • Find any employees who earn less than the employee hired immediately after them [closed]
  • SQL Server Replication Agent Permission
  • Index usage on a temporary table
  • MySQL – Simple update is very slow and causing high load average with large amount of server
  • PostgreSQL is not using index with large data
  • During installation can’t change directory
  • Column order for better index
  • Why is this PostgreSQL volatile function faster than an inline subquery?
  • Ignoring temp table in Postgres event trigger
  • How do I get the difference in minutes from 2 timestamp columns?

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