Question : I have a job that runs every 5 minutes to check an IF condition. If the condition is […]
Tag: sql-server-agent
Why does an SQL Server Agent job try to create a procedure
Question : I am using SQL Agent to schedule the exeuction of a procedure. The first time that the procedure […]
What is considered for output from an sql server job step?
Question : In short: It seems I only get PRINT messages to my SQL Server job history. What is the […]
Rebuild Indexes [duplicate]
Question : This question already has answers here: Why do we need to rebuild and reorganize Indexes in SQL Server […]
Sql Server Agent notification email with custom message
Question : I have set email notification on the completition of a scheduled job. Is it possible to customize the […]
Complex SQL Agent Job
Question : I would like to tun the Stored Procedures on the following dates. 1st sept 2020 1st Nov 2020 […]
Stop Changes to Maintenance Plan from Renaming Linked SQL Agent Job
Question : Is there a way to stop a SQL job (which calls a maintenance plan) from being renamed every […]
Measure Agent Job failure and running jobs with ‘execution_status’
Question : Considerations I need to create a Dashboard with job failure AND running jobs. I have a code to […]
How can I have SQL Server send Job Notification alerts to an API
Question : I am trying to get the notifications for a job out of my email and into a chat […]
Notification when the status on sql server replication is “Not Running”
Question : We have a lot of replications set up. Sometimes for some reason, the status of the replication changes […]