Your search for "sql server agent" returned 100 results:
Hello, I use SQL 2019. I have a job that runs yearly. For some odd reason the date changed on it. Now when I try to set a new date for it under job activity monitor it will just stay on the incorrect date. I just updated the Windows, and restarted it. I also restarted […]
2024-01-17
798 reads
Installed two named instances of sql 2019. In one of the instances, I am seeing login failed for user 'mydomain\sqlagentserviceaccount' reason: could not find a login matching the name provided. The time the message gets lodged is the time when syspolicy_purge_history runs. I ran that job manually earlier and that time it didn't seem to […]
2021-06-28
943 reads
Hi all, SQL Server 2008 r2 SP1 (Dev edition) on Windows 2008 r2. Everything was working fine. someone has done something (No idea no hands up either) and the Agent wont start now. Ive looked at some other posts and none have helped. Im using a domain account. password is checked no worries there (Its […]
2012-03-12
1,263 reads
I'm running SQL Server 2005. I have about 100 SQL Jobs, most of them have been running for years. All of them are configured to send EMAILs on failure and they have been working fine up until yesterday at 4 PM. All of a sudden, every time a SQL job started it would trigger the […]
2014-05-28
744 reads
This has been a multiple-day effort to troubleshoot this, so I'll try to be as concise as possible in the hopes that someone has a suggestion that will get this working for me. Rightclicking on 'Database Mail' and selecting 'send test email' works. Putting the following SQL code in a job step works when the […]
2011-09-29
1,242 reads
Hello, I have these messages while trying to start the Agent. Knowing that a day before, it worked without any problems : all the tasks were well scheduled and executed. - Type: Error Source: SQLAGENT$C1TEST Category: Service Control Event ID: 103 Date: 07/08/2010 Time: 10:16:30 AM User: N/A Computer: MyServer Description: SQLServerAgent could not be […]
2010-08-11
9,271 reads
I'm trying to configure mail notifications on a job, and i read up a few things online which i had already done and then i restarted the SQL Server Agent as advised, but it would not restart. Right now, it shows beside it's icon as SQL Server Agent(Agent XP's disabled). when i try to start […]
2008-03-06
2,104 reads
Tired of the truncated error history that is available for SQL Server Agent jobs in SSMS, here is a way to get deeper information - easily!
2009-09-09
40,774 reads
I am running Reporting Services in SQL Server 2000.Is there any way of giving a subscription job a decent name, other than the automatic ED33F142-1F6B-4618-9B2F-7BD3FD63CC34 etc? Not exactly an easy name to remember, nor one which helps to identify which job does what. (You can rename Backup jobs with no problem).Having submitted several jobs for […]
2006-01-27
1,987 reads
A few days ago, my SQL Agent Jobs stopped logging to the history table. They don't show up in view-history and they are not in the sysjobhistory table. I do limit to 10000 rows with max 500 rows per job, but I've also tried not limiting it at all. The SQL Agent servers runs under […]
2021-07-26
1,350 reads
pg_cron is a simple cron-based job scheduler for PostgreSQL that runs inside the database...
By Steve Jones
I heard someone say recently that you can’t change a primary key value in...
By Kevin3NF
Indexes 101: What, Why, and When? “What Is an Index?” I get this question...
Comments posted to this topic are about the item 50 Years of Microsoft
Comments posted to this topic are about the item Multiple Collations
Comments posted to this topic are about the item Retrieving Data Using the REST...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers