Is it possible to schedule a job to automatically send e-mails based on criteria in a database table, maybe using CDONTS? I don't want to use SQLMail, since my administrator has not set that up. Also, I don't want to write the code in an ASP page for the following reason: If the page is not being viewed at the time I want the e-mail to be sent, it won't work. Besides, it's not efficient to have to read this code for no reason every time a page is loaded in the hopes someone loads it at the correct time. Any suggestions?
when I run a package from a command window using dtexec, the job immediately says success. DTExec: The package execution returned DTSER_SUCCESS (0). Started: 3:37:41 PM Finished: 3:37:43 PM Elapsed: 2.719 seconds
However the Job is still in th agent and the status is executing. The implications of this are not good. Is this how the sql server agent job task is supposed to work by design.
We just moved source server to newer, bigger box ... Windows 2003 and Active Directory ... Snapshot agent worked but distribution failed ... Same login as on older machine, login is sysadm, used DCOMCNFG to allow ability to launch process ... What are we missing?
I would appreciate any help here at all. I am pulling my hair out!
I am unable to start the snapshot agent or log reader agent from within SQL management studio. it fails on executing step 2 with unknown username or bad password.
I have checked all account details and they are correctly using my domain admin account. I can connect to SQL using teh same account and it also has sysadmin permissions.
If i copy the step 2 paramters and start from the cmd prompt (again logged in using the same domain account) they both start fine.
I am testing peer to peer replication in our environment. I simulated a three node peer to peer topology and a local distributor.
For some wierd reason I cannot get the Log Reader Agent and snapshot agent to start. The domain account under which SQL Server Agent runs has administrator previlage on the box. I also use a domain account for SQL Server Service. (none of the passwords changed).
This is the error I am getting - "Executed as user: abc. A required privilege is not held by the client. The step failed"
While I was out of the office the Lan Team moved one of my SQL Server2000 servers to a new network domain. Since then the maintenance jobhas not ran.The error log for the SQL Agents has the message listed in the subjectline. I have not found any useful articles on the MS SQL Serversite. Anyone know what might be wrong and how to fix it.HTH -- Mark D Powell --
Hi. I have installed an SQL 2005 Failover Cluster on a Two Node Active Passive Windows 2003 Cluster.If i am trying to failover from the Active node to the passive Node,The Sql Server,Sql Server Agent and SQL Analysis resources fail,However if i reset the passowrd in the services tab of the above three services on the pasive node,the resources come online. Below is the brief of my setup 1.I have two Active directory domain controllers running Windows 2003 R2 Standard edition with SP2. 2.i have installed a Windows 2003 Two Node Active Passive Cluster as NODE1 and NODE2. 3.The Domain account used to install WIndows 2003 A/P Cluster is Clusteradmin.This account is the member of Administartors on the Domain as well as the Local Admin on NODE1 and NODE2. 4.SQL 2005 with SP2 is installed on both the Nodes as SQL 2005 Failover Cluster.The account used to install SQL 2005 is sqadmin.This account is the member of Administartors on the domain and the member of Local Admins on NODE1 and NODE2. 5.SLQ 2005 has four domain groups for 4 SQL Services.The Services are SQL Server,SQL Server Agent,SLQ Anaylisis Server and Full text Search. 6.Each of these servcie has a seperate service account created for them.All these service accounts areb the members of domain admin and the member of Local Admin on NODE1 and NODE2. 7.Each of these servcies is running under these servcie accounts in the Servcies tab in NODE1 and NODE2. 8.If i fail the resources from NODE1 to NODE2 ,The SQL Server,SQL Server Agent and SQL Anaylisis resources are failing.on going to the service tab of NODE 2 I reset the password for these services,the services come online. 10.The Cluster resources and MSDTC Resources are Failing over successfully.They are coming online successfully. 11,I have a problem with the SQL Server Resources,even if i failback to NODE1 from NODE2,the same resources are failing again.
Is there a difference with sql replication between sql server 2005 64bit and sql server 2005 32bit? Both are on a Windows 2003 server. One is 32 bit and the other one is 64 bit. The first time I set up sql replication (test environment), it was on a 32 bit sql server. This worked fine. The second time I wanted to set up replication (live environment), it was on a 64 bit sql server. This didn't worked fine.
I can't call the sqlcesa30.dll file on the 64bit server with IIS. So I called the dll via a remote IIS server. This worked but gave me the following error when calling the following URL: http://domain/PDASYNC/sqlcesa30.dll?diag
SQL Server Mobile Server Agent Diagnostics 2007/07/31 14:26:55
General Information
Item Value
Server Name domain
URL /PDASYNC/sqlcesa30.dll
Authentication Type Anonymous
Server Port 80
HTTPS off
Server Software Microsoft-IIS/6.0
Replication Allowed
RDA Allowed
Logging Level 0
Impersonation and Access Tests
Action Status ErrorCode
Impersonate User SUCCESS 0x0
ReadWriteDeleteMessageFile FAILURE 80070003
SQL Server Mobile Modules Test
Module Status ErrorCode Version
SQLCERP30.DLL SUCCESS 0x0 3.0.5207.0
SQLCESA30.DLL SUCCESS 0x0 Unknown
Reconciler Test
Reconciler Status ErrorCode
9.0 Database Reconciler SUCCESS 0x0
8.0 Database Reconciler FAILURE 0x8007007E
SQL Server Module Versions
Module Version
sqloledb.dll 2000.86.1830.0
9.0 replrec.dll 2005.90.2047.0
9.0 replprov.dll 2005.90.2047.0
9.0 msgprox.dll 2005.90.2047.0
8.0 replrec.dll 2000.80.760.0
8.0 replprov.dll 2000.80.760.0
8.0 msgprox.dll 2000.80.760.0
After seeing this I looked up what ReadWriteDeleteMessageFile could mean. It appeared to be some NTFS acces problem. But when I checked the security settings, it all seemed to be ok.
Has anyone any idea what else to check? Or is sure that I must have done something wrong?
Sql server agent is running under a domain account that is a member of administrators and domain users amongst others, and the package is executed as the service account. Connecting to servers on the same domain works and when I run it from the msdb package store in ssis (ssis runs under the network service account ...) it will connect to the pop server as well. Permissions, fiddly proxies .. the answer's out there somewhere
The SQL Server Agent (MSSQLSERVER) service on server started and then stopped. If i Manually start the services also SQL Server Agent services are stopping automatically.Though I selected Auto Restart SQL Server Agent if it stops unexpectedly, The services are stopping automatically.TCP/IP protocol was enabled for port 1433.Are there any setup I missed?
Hello everyone !!! I need to do a process that run every day to update some data, but my sql server version (express 2005) does not have job agent service. Does anyone can give me a suggestion of what to do? Thank you!
Hi there, was wondering if any can tell me why the following jobs keeps failing: INSERT INTO TblActivityBookingArchive SELECT * FROM TblActivityBooking WHERE (expiryDate <= GETDATE()) it retuens that it is successful when there is no data to archive from TblActivityBooking, it's when there is data to archive that it returns that the job has failed. Hope you can help Thanks Mel
I am unable to start SQL Server Agent. When I try, I get this message: "An Error 1053 - (The service did not respond to the stort or control request in a timely fashion) occurred while performing this service operation on the SqlServerAgent service."
We received the error messages below (in the SQLAgent Log) when trying to execute a SQL Job manually. These errors do not appear if the job is executed automatically, and consequently runs smoothly. Only when we try to kick off the job manually does it fail and report these errors.
3/20/01 4:27:16 AM - ! [000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client) 3/20/01 4:27:16 AM - ! [000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: A required privilege is not held by the client)
If anyone has any insight into this issue it would be greatly appreciated.
My sql server agent is not starting and whenever I try to start a job it gives me an error saying that job csnnot be started as sql server agent is not running...and it open a black window(with title bar d:mssql7insqlagent.exe)..can anyone tell me the reason for that and how do I get around this problem.
Attempted to start the SQL Server Agent in Services and got this error message: 'Error 2140: An Internal Windows NT error occured'. Does anyone know what I need to do or fix? Any help would be greatly appreciated. Thanks.
Need immediate help trying to figure this message out. We are having immediate problems trying to start the SQLServer Agent, the service that runs the Scheduled Tasks and needs to be reset if NT connectivity has been interrupted to keep SQL Mail on-line, is not responding and generating the following message. All DBAs that might know something about this problem, would you please respond immediately. We can't have our SQL Server Agent down and not responding.
[000] Password verification of the 'SQLAgentCmdExec' proxy account failed (reason: Logon failure: the user has not been granted the requested logon type at this computer)
Thanks for all your help and solutions in getting to an answer. Sincerely, Daimon Russell
In SQL Server 2000, how can I set up SQL Server Agent to automatically start up when SQL Server starts up ? I do NOT want these to start up when the OS starts (so setting them to automatic in Control Panel Services is no good). When I shut down SQL Server the SQL Server Agent does automatically shut down too but I cannot get it to start up.
I am running 3 instances of SQL2000 SP3a on a windows 2000 server. Over the weekend, the server was restarted due to security patches being applied. All 3 instances are setup the same (Automatically start SQL Server Agent when restarting server). The 2 named instances started the agent fine but the default instance did not. There are no errors in the log. When I started it manually this morning, it started fine with no errors. Does anyone have any idea why the agent would not have started automatically?
I need to take the databases offline and stop the SQL Server Agent. If I stop the SQL Server Agent first, will I be able to take the databases offline?
I want to sendmail after finishing job by using SQl Server Agent.When I try to change SQL Server Agent start up account from new account in windowsxp system , I give new account a right of 'Log oOn as a Service Right ',but I experience the error the following. Error 22042 xp_setsqlsecurity() returned error- 2147023564 'No mapping between account name and security IDs was done'
Lets say I have a SQL Server Agent job that has several steps. For our example lets say 2 steps. Each step executes stored procedures with output parameters like so:
Step 1: EXECUTE <db>.<schema>.<proc A> @outputVar=@outputVar OUTPUT Step 2: EXECUTE <db>.<schema>.<proc A> @inputVar=@outputVar
Is it possible to pass the @outputVar variable as an input to the procedure in step 2?
I've created a stored procedure that will send out an email to users who have over due items. I'm now ready to set it up in SQL 2005 to run as a job. How do I add my stored procedure to that job I know how to set it up to run. I'm looking in SQL Server Agent but don't see how to add it to the Job. Please assist.
In SQL Server 2005. I am trying to figure out why I cannot ad a step when I am trying to create a job. I am able to create a job but it won't let me add any steps to that job. I am even configured as an administrator on the server and still have problems with this. Does anyone know how I can get around this?
Hi, I have a job that runs a ssis package but the job will not execute the second step which uses a 3rd party software to download a file from a sftp server. My logon is in the admin group, I am using Local System as the logon service for sqlserver agent, my account has sysadmin server role in sqlserver, I added my account to logon as a service and batch job in local services, my account created the package. The package will execute fine using dtexec and windows task scheduler. I've even tried scheduling the job with a proxy and that won't work either. i'm running xp prof. Any other ideas? Here is the error:
Microsoft (R) SQL Server Execute Package Utility Version 9.00.3042.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 9:13:14 AM Error: 2007-09-25 09:13:17.62 Code: 0xC0029151 Source: Execute Process Task Execute Process Task Description: In Executing "C:Documents and SettingsmroushDesktopSQL 2005 DMS project-ProdWinSCP3WinSCP3.com" "/script="C:Documents and SettingsmroushDesktopSQL 2005 DMS project-ProdDownload E-Appssftpscript.txt"" at "", The process exit code was "1" while the expected was "0". End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 9:13:14 AM Finished: 9:13:17 AM Elapsed: 2.875 seconds
Hi All, I deploy my ssis package on sql 2005 Integration Services and I am also able to run the package from Integration ServicesStored Packages. However, when I create a job and try to execute the job, I get the following error:
Description: "Login failed for user 'PQBSNETRFWSQLSTG2$'.". End Error Error: 2007-10-29 15:49:43.74 Code: 0xC020801C.
I am told by the dba that they have created an admin account for me on the server and I should be able to execute the job without any problem.
I am lost as to why I am not able to run the job. Any help would be greatly appricated.
I have set up a job under SQL server Agent to execute a stored procedure that will update a table in my database.
I set the job to run after the SQL Server Agent starts. According to the job history, the job ran successfully but there was no updated record in my table. However, if I manually restart then SQL Server Agent, the table is updated.
Is is something wrong with the SQL Server Agent or must the job be run twice for it to update?
I have 2 SSIS Packages and they are executed via stored procedures. For example consider below 2 stored procedures which dynamically creates a Job and then starts executing the Job.
i,e when i say EXEC spExecDTS_Package1 in SQL Server Management Studio (i.e Query Analyzer), This stored procedure dynamically creates a job and starts executing the SSIS Package1. Inside this PAckage1, the last step is an "Execute SQL Task" which will be calling the 2nd stored procedure responsibele for calling the Package2.
IF u can see the below code, u can clearly understand.
But now my requirement is , i dont want create one more job for calling the 2nd Package. Instead what i need to do is that, i need to get the jobid of the first package and i need to add one more job step2 to it with the @cmd written inside the second stored procedure to call the 2nd Package.
Bottom - line, i dont want create a new job instead only add a new job step to existing running job.
How a job step can be added within "Execute SQL Task ". How would be logic will be implemented.
Any help on this will be greatly appreciated.
Thanks!
create procedure [dbo].[spExecDTS_Package1] AS DECLARE @jid uniqueidentifier declare @cmd varchar(4000)
