SQL Server Jobs

Question

Post reply

SQL Server Jobs

lankenr

Mr or Mrs. 500

Points: 547
More actions
November 25, 2009 at 11:43 pm

#385853

Comments posted to this topic are about the item SQL Server Jobs

Viewing 15 posts - 1 through 15 (of 27 total)

You must be logged in to reply to this topic. Login to reply

Robbert Hof SSCrazy Points: 2778 More actions · Answer 1

Are you able to start SQL Server Agent in SQL Server 2008 Express Edition?

I can't find any proof of this.

According to http://msdn.microsoft.com/en-us/library/cc645993.aspx it is not supported.

Please explain.

thanks,

Robbert

dawryn SSCertifiable Points: 5481 More actions · Answer 2

According to http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx (SQL Server 2008 - Compare Edition Features) under Enterprise Manageability there is no SQL Server Agent in Express Edition:exclamationmark:

How does anyone create and execute a job without this service?

vk-kirov SSCertifiable Points: 7686 More actions · Answer 3

Ref: Editions and Components of SQL Server 2005 - http://msdn.microsoft.com/en-us/library/ms144275%28SQL.90%29.aspx

I can't see anything about jobs there. The link seems to be not relevant to the question.

dawryn SSCertifiable Points: 5481 More actions · Answer 4

I can't see anything about jobs there. The link seems to be not relevant to the question.

What is the use of a job if there is no service to be executed (scheduled) with? Any new features in 2008 Express?

See http://msdn.microsoft.com/en-us/library/ms190268.aspx:exclamation:

2. Expand SQL Server Agent.

EdVassie SSC Guru Points: 60472 More actions · Answer 5

We have had a number of questions which included a deliberate spelling error that had an answer xxx is wrong because it does not exist. As far as I know 'Enterprize' edition does not exist, but I have heard of 'Enterprise' edition and would have selected that if it was given in the question.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

EdVassie SSC Guru Points: 60472 More actions · Answer 6

You can get SQL Agent on SQL 2008 Express Edition to start. You need to set up account rights and enable the agent XPs.

But as soon as it starts it gives a message that Agent is not supported on Express edition and then stops. IMHO this is a case where you win the battle but loose the war.

Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

vk-kirov SSCertifiable Points: 7686 More actions · Answer 7

dawryn (11/26/2009)
I can't see anything about jobs there. The link seems to be not relevant to the question.
What is the use of a job if there is no service to be executed (scheduled) with? Any new features in 2008 Express?

This was not a reply to your post, I know about the relation between jobs and SQL Server Agent 😎

I quoted the link from the explanation of the question. That link contains nothing about jobs and SQL Server Agents and should be corrected.

dawryn SSCertifiable Points: 5481 More actions · Answer 8

vk-kirov... That link contains nothing about jobs and SQL Server Agents and should be corrected.

Done (it was under first result)

MarkusB SSC-Dedicated Points: 37370 More actions · Answer 9

Strictly speaking you can create a job in SQL 2005 Express as well. All the necessary stored procedures in the msdb are there and you can execute them succesfully. You cannot execute them on a schedule because there's no SQL Agent, but a job exists.

Just try this:

USE msdb ;

GO

EXEC dbo.sp_add_job

@job_name = N'Daily Backup' ;

GO

select * from sysjobs

GO

Exec dbo.sp_delete_job @job_name = N'Daily Backup' ;

I think the question should be in which version can you execute jobs on a schedule.

[font="Verdana"]Markus Bohse[/font]

dawryn SSCertifiable Points: 5481 More actions · Answer 10

Another QoD turned sour

And it will be covered with educational purposes :Whistling:

Atif-ullah Sheikh SSChampion Points: 12495 More actions · Answer 11

What to say...?

SQL Agent is installed with SQL Server 2008 Express but cannot be started.

So the creation of job is meaning less if you cannot execute it.

Lost my point....

----------------------------------------------------------------------------------------------------------------------------------------------------------------------

Sometimes, winning is not an issue but trying.
You can check my BLOG [font="Arial Black"]here[/font][/url][/right]

Dude76 Mr or Mrs. 500 Points: 585 More actions · Answer 12

So, it seems i'm not alone being trapped by create/schedule a job for the 2008 Express Edition 😀

My MCP Transcript (ID : 692471 Access : 109741229)

timfle SSC Eights! Points: 932 More actions · Answer 13

poor question, poor explanation

and I do not agree with the "supposed" answer - but then why should we expect the "author" to know what he/she is talking about when they can't even spell "enterprise"?

sqljohn (twitter) SSC Enthusiast Points: 193 More actions · Answer 14

so technically you CAN create the jobs but it is meaningless because they will never be run. tis a bit misleading if someone just reads the answer and not the forum, then runs off to install express