SQL Server Agent - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SQL Server Agent

Author

Topic

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2011-09-20 : 06:23:48

Hi,

I right click on the SQL SERVER AGENT and optioned to Restart.
It worked fine..

Now, am trying to run a job which has been scheduled to run every 15 minutes and it is not responding and the job is not executed.

I tried to Refresh the SQL Server Agent, but am experiencing the same problem.

Can anyone tell the problem please - as to why it is not executed..
The job was working fine prior to the Restart of the Agent.

Thanks
Riyadh

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-20 : 06:27:26

check if schedule of job as well as the job is enabled first

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2011-09-20 : 06:32:04

Schedule of the job is ENABLED.
However, the Job itself Enable is Greyed out - meaning its enabled.. Right?
Note: I even tried to create a new job from scratch and set it to start like in 5 minutes.. The time passed and the job was not executed.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-20 : 07:17:26

quote:
Originally posted by dr223

Schedule of the job is ENABLED.
However, the Job itself Enable is Greyed out - meaning its enabled.. Right?
Note: I even tried to create a new job from scratch and set it to start like in 5 minutes.. The time passed and the job was not executed.

i feel like sql agent service is not started.
check in services.msc and see if its running.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2011-09-20 : 07:58:13

Rebooted the entire server - it still doesnt work
Check SQL Agent at Services.msc and it's started

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-20 : 08:11:17

check in services.msc and see if sql agent service is running and its start mode is automatic

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2011-09-20 : 08:17:22

ok - On Services.msc this is what I have

SQL Server (VDTManager) Started Automatic
SQL Server Agent (VDTManager) Started Automatic
SQL Server Browser Started Automatic
SQL Server FullText Search (VDTManager) Started Automatic
SQL Server VSS Writer Started Automatic

I am checking the right place? Is this what you mean?

Thanks

dr223
Constraint Violating Yak Guru

444 Posts

Posted - 2011-09-20 : 10:29:52

Tried to start the job manually-

Right Click - SQL Server Agent - Jobs - UnzipUtility (job name)

Error:

Start Jon 'UnZippingUtility' Status - Error Message: Start failed for job 'UnZippingUtility'.(Microsoft.SQlServer.Smo)

Microsoft.SQlServer.Smo

Start failed for job 'UnZippingUtility'

SQLServerAgent Error: Request to run job UnZippingUtility (From User sa) refused because the job is already running from a request by
User sa. (Microsoft SQL Server, Error:22022)

Any help please..

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-20 : 10:40:24

that does indicate that job is already in running state. did you have a look at agent activity monitor to check if its running currently?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources