sql-server-agent Archives

How to stop a job for the rest of the day after the relevant condition has been satisfied once?

By adminPosted on May 28, 2023

Question : I have a job that runs every 5 minutes to check an IF condition. If the condition is […]

By adminPosted on May 26, 2023

Question : I am using SQL Agent to schedule the exeuction of a procedure. The first time that the procedure […]

By adminPosted on May 13, 2023

Question : In short: It seems I only get PRINT messages to my SQL Server job history. What is the […]

By adminPosted on May 10, 2023

Question : This question already has answers here: Why do we need to rebuild and reorganize Indexes in SQL Server […]

By adminPosted on May 7, 2023

Question : I have set email notification on the completition of a scheduled job. Is it possible to customize the […]

By adminPosted on May 6, 2023

Question : I would like to tun the Stored Procedures on the following dates. 1st sept 2020 1st Nov 2020 […]

By adminPosted on April 25, 2023

Question : Is there a way to stop a SQL job (which calls a maintenance plan) from being renamed every […]

By adminPosted on April 24, 2023

Question : Considerations I need to create a Dashboard with job failure AND running jobs. I have a code to […]

By adminPosted on April 22, 2023

Question : I am trying to get the notifications for a job out of my email and into a chat […]

By adminPosted on April 9, 2023

Question : We have a lot of replications set up. Sometimes for some reason, the status of the replication changes […]