.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
sivanagamahesh
Post New Web Links

Sqlserver Agent not able to start the JOB.

Posted By:      Posted Date: November 29, 2010    Points: 0   Category :Sql Server
 

I am having one pakage which execute one DOS batch file to operate a FTP task(Pulling files).

Its working fine with SSIS.

When Scheduling with SQLSERVER Agent Jobs its not working and status showing as "in progress". tried with different user IDs like "sa", Local User Account etc.

 




View Complete Post


More Related Resource Links

sql server 2008 - sqlserver(mssqlserver) services can't start

  
Sorry i need help, i have instal and reinstal sql 2008 over and over but always failed the problem is the services can't start and when i cek error log this written: http%3a%2f%2fgo.microsoft.com%2ffwlink%3fLinkId%3d20476%26ProdName%3dMicrosoft%2bSQL%2bServer%26EvtSrc%3dsetup.rll%26EvtID%3d50000%26ProdVer%3d10.0.1600.22%26EvtType%3d0xE53883A0%400xBE03358B%401306%4024

SQL Server 2008 Agent Fails to start in a Win 2008 Cluster

  
When I try to bring SQLAGENT Online, I get the following errors: EventID:53 [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service.  CurrentState: 1 [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] OnlineThread: Error 435 bringing resource online.   I just did a fresh SQL Cluster install as well.  When I installed the cluster, the service account was good to go.  I cant figure out what is going on.  SQL Server Engine starts fine.  Any ideas?

User proc must start Agent job -- how?

  
My app must allow users to start a SQL Agent job to do a background operation.  I found a discussion on this and attempted to implement the last solution therein:
use [MyDB];
go

create PROCEDURE dbo.spStartAgentJob
	@pvJobName	nvarchar(100)
	WITH EXECUTE AS 'agentProxy'
AS
EXEC msdb.dbo.sp_start_job @pvJobName
return
GO

create certificate agentProxy 
    ENCRYPTION BY PASSWORD = 'pGFD4bb925DGvbd2439587y'
    with subject = 'agentProxy'
   , expiry_date='01/01/2100';
go

ADD SIGNATURE TO OBJECT::[spStartAgentJob]
      BY CERTIFICATE [agentProxy]
        WITH PASSWORD = 'pGFD4bb925DGvbd2439587y';
go

alter certificate [agentProxy] 
  remove private key;
go

backup certificate [agentProxy] 
 to file='c:\temp\agentProxy.cer';
go

use msdb
go

create certificate [agentProxy] 
  from file='c:\temp\agentProxy.cer';
go

create user [agentProxyAuthenticator] 
 from certificate [agentProxy];
go

grant authenticate to [agentProxyAuthenticator];
grant execute on msdb.dbo.sp_start_job to [agentProxyAuthenticator];
go

use [MyDB];
go

exec dbo.spStartAgentJob N'test'
go 
The EXECUTE permission was denied on the object 'sp_start_job', database 'msdb', schema 'dbo'.


Did I miss something?  What is the correct way to accompli

Upgraded SQLServer 2008 Enterprise Evaluation after 180 day period expired...Services start but stil

  

Hello,

I have a SQLServer 2008 Enterprise (180 day eval) installation that had expired.

I downloaded and intalled SQLServer 2008 Enterprise (Full version) from Technet

and ran the "Version Upgrade" tool.

The Upgrade tool correctly identified the expired instance and reported that it

had successfully upgraded the expired instance.

The OS processes will start but when I attempt a connect, I get a "Evaluation Period Expired"

error message.

Is it possible to do an "upgrade in place" after the 180 day evaluation has expired or do

you have to uninstall then re-install ?

Many Thanks in Advance,

Hobson Black


Cannot start SQL Agent (2008)

  
I have a server with SQL Express 2008 running on it. 

SQL Agent service appears to be disabled, but when I try and start it I get the following error:

the sql server agent (SQLEXPRESS) service on local computer started and the stopped. Some services stop automatically if they have no work to do for example the Performance Logs and Alerts Service.

Anyone know whats causing this?

Couldn't start the distributor agent

  

Initially i had replication and then i have deleted the replication.When i redo the replication ,distributor agent is not starting.i got following error

SQLServerAgent Error: Request to run job FED-DB1-XXXX-XXXX_Pulbi-FED-DB2-19(From User sa) refused because the job is already running from a request by user sa.
Changed database context to 'XXXXXX'.(Microsoft SQL Server,Error:22022)'.

I have select the distributor agent in same publisher server.Please help me out of this.


Is there a way to start SQL Agent from Transact-SQL or SSMS?

  

Using SQL Server 2008 is there a way to start the SQL Agent service using T-SQL? I don't have remote desktop permissions to that server or I would try to start it from there. While connected to the server in SSMS, in object explorer, if I right-click on the The SQL Server Agent label I see the start and stop options but they are greyed-out. Why?

precise version: Microsoft SQL Server 2008 (SP1) - 10.0.2531.0 (X64)   Mar 29 2009 10:11:52   Copyright (c) 1988-2008 Microsoft Corporation  Enterprise Edition (64-bit) on Windows NT 6.0 <X64> (Build 6001: Service Pack 1)


Cannot start SQL Server Agent service on Cluster , 2008 R2

  

Hi,

I'm testing a two node cluster installation on windows 2008 r2 and sql server 2008 r2 both enterprise before a production deployment and my only issue so far is that the SQl Server Agent service cannot be started.

The failover works fine, the cluster and SQL services changes nodes without any problem but on both nodes i cannot start that service.

I'm using a domain user for the service, member of the local admin and sysadmin on the SQL server itself.

The error i get when i click on start from SQL management console is:

Unable to start service SQLAGENT$SQLTEST on server SERVERNAME. (mscorlib)

------------------------------
Program Location:


Server stack trace: 
 at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.Service.Start()
 at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args,
 Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md,
 Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[]& outArgs) at System.Runtime.Remoting.Messaging.StackBuilderSink.AsyncProcessMessage(IMessage msg, IMessageSink
replySink) Exception rethrown at [0]: at System.Runtime.Remoting.Proxies.R

Unable to start sql server Agent

  

Hi

 

I am not able to start the Sql server Agent, when I am trying to start it is displaying the error msg "The Dependent services has not started"

 

Please help me in this issue


Unable to enum ManagedComputer.Services & Stop/Start SQL Agent service from ASP.NET app

  
Hi guys

I have some code that stops/starts the SQL Server Agent service from within our ASP.NET web application.  Runs fine in development but doesn't in release - I suspect due to rights: Dev has admin rights, whereas Prod is running under a IIS application pool identity which is a domain account (e.g. IUSR_WEBAPP).

In Production it doesn't return any ManagedComputer.Services - ManagedComputer.Services.Count = 0. It doesn't throw any exceptions or anything, just not return any services or allow me to access the specific SQL Agent instance that I want to.

I've tried granting access in various places including WMI but nothing seems to work.  I cannot figure out what rights might be needed.

How can I grant access to my application pool account so that it can enumerate services and stop/start my specific SQL Agent account instance for 2005/2008?

Many thanks
Reg

System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseColl

  

Hi All,

I am getting the following error while trying to invoke a DB JOB from my application code.

System.TypeLoadException: Could not load type 'Microsoft.SqlServer.Management.Smo.Agent.JobBaseCollection' from assembly 'Microsoft.SqlServer.Smo, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91

I have installed my code in application server and the DB where the sql jobs are installed is in another server. (Different physical servers).

When I analysed, I could see that the Application server has Microsoft.SqlServer.Smo version 9.0.242.0 in its GAC. The DB server has got both 9.0.242.0 and 10.0.0.0 versions of the same DLL in its GAC.

I wonder whether this can cause the issue.

Any help is appreciated.

With regards,

Error in connecting to SQLServer 2005 from Management studio and neither able to start sql service

  

I had been using SQL server 2005 without any problem but a few days back I started having some problem with my Windows XP Professional sp2 that my pc used to go off after 5-7 mins everytime i started it. So I repaired the OS. Since then,when i opened SQL Server and tried to connect am getting this error---

TITLE: Connect to Server


Cannot connect to POONAM-C586A95C\SQLEXPRESS.


ADDITIONAL INFORMATION:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I checked the state of sql serverand it is stopped. What should I do to bring it to running state?

I even added sqlservr exe file to the exceptions in the firewall but i dont think that could hav been a problem b'coz it was working perfectly without any changes in the firewall setting.

Why am I getting this error and how can I remove it?

Please help.


SharePoint 2007 Workflows - Things to Consider Before You Start

  
SharePoint 2007 (MOSS) utilizes the Workflow Foundation (WF) to enable workflows on lists and content types. But before you start doing cartwheels there are few things you should know before you get started. The experiences I'll be discussing are not from book smarts but from building real MOSS solutions that are in production today.

How to Encrypt and Decrypt a Password using SQLSERVER 2005?(Video)

  
Encypt and Decrypt a Password using SQLSERVER 2005(Video)

Date and Time Functions in SQLSERVER

  
Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
4 GETDATE and GETUTCDATE Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

  
Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

Setting the default start page in godaddy hosting?

  

 How do you set the start page with godaddy hosting? I can see no way of doing this! You do not seem to have access to the IIS settings that allow you to change it!


Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend