Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

SQL Server Jobs Expand / Collapse
Author
Message
Posted Thursday, November 26, 2009 4:54 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, July 10, 2014 1:48 AM
Points: 2,359, Visits: 730
Another QoD turned sour
And it will be covered with educational purposes
Post #825168
Posted Thursday, November 26, 2009 5:19 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, June 27, 2014 8:02 AM
Points: 3,241, Visits: 4,996
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 here

Post #825176
Posted Thursday, November 26, 2009 8:04 AM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, March 18, 2013 7:52 PM
Points: 280, Visits: 88
So, it seems i'm not alone being trapped by create/schedule a job for the 2008 Express Edition :D


My MCP Transcript (ID : 692471 Access : 109741229)
Post #825235
Posted Thursday, November 26, 2009 2:56 PM
Right there with Babe

Right there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with BabeRight there with Babe

Group: General Forum Members
Last Login: Today @ 1:32 PM
Points: 718, Visits: 107
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"?




Post #825375
Posted Thursday, November 26, 2009 3:21 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Sunday, December 15, 2013 9:40 PM
Points: 160, Visits: 68
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
Post #825378
Posted Thursday, November 26, 2009 6:35 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 4:09 PM
Points: 21,252, Visits: 14,960
MarkusB (11/26/2009)
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.



I would have to agree with this. The question in this scenario just does not quite seem to match properly. The question asks what editions can you create a job in SQL Server, far different from being able to schedule a job.




Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp
Post #825395
Posted Friday, November 27, 2009 5:54 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 6:57 AM
Points: 982, Visits: 752
I think this is one for Steve (Jones):

There have been a number of QoDs lately that appear to be designed deliberately to mislead, on the pretext that everyone will get it wrong and "learn from the experience". Trouble is, it just makes people cynical about QoD in general and stop them even trying to answer, because answering correctly isn't based on skill or knowledge, rather it is a simple but annoying game of chance.
Post #825581
Posted Friday, November 27, 2009 7:00 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Friday, May 24, 2013 5:20 AM
Points: 660, Visits: 558
dawryn (11/26/2009)
Another QoD turned sour
And it will be covered with educational purposes


Hey, but at least we learned something, right?
Oh, wait...


--------
I love deadlines. I like the whooshing sound they make as they fly by. -Douglas Adams
Post #825607
Posted Friday, November 27, 2009 9:07 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 9:50 PM
Points: 23,045, Visits: 31,570
Well, I can't defend this one. I have to agree, what good is it to create the job if you can't run it?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #825655
Posted Friday, November 27, 2009 9:43 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Friday, July 18, 2014 3:37 PM
Points: 3,125, Visits: 1,256
I don't think I learned anything useful by getting this question wrong. Who cares if you can create a job in express if it can't be used?


Post #825676
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse