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 ««12

A SQL Job of mine isn't running. I don't know why not. Expand / Collapse
Author
Message
Posted Thursday, January 02, 2014 3:04 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, February 20, 2014 12:11 PM
Points: 20, Visits: 127
also, make sure job is enabled.
Post #1527300
Posted Friday, January 03, 2014 7:41 AM
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: Thursday, April 10, 2014 1:08 PM
Points: 721, Visits: 1,264
Jeffrey Williams 3188 (1/2/2014)
Edit the schedule on the job - you should see a section for Duration. In that section, you will have a Start date - for this job, that start date must be in one of the months where you expect the job to run.

Please let us know what that start date is.


The start date is 1/1/2009, with no end date specified.



Kindest Regards,

Rod
Post #1527537
Posted Friday, January 03, 2014 7:44 AM
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: Thursday, April 10, 2014 1:08 PM
Points: 721, Visits: 1,264
Jeffrey Williams 3188 (1/2/2014)
You can also find the next scheduled run from the Job Activity Monitor. Open that - and you will see a column for 'Last Run' and 'Next Run'.


I didn't know that the Job Activity Monitor would show me that information. According to that the Next Run is 2/1/2014 at 12:05 AM. That is not the date I want it to run next! I want the next run date to be 4/1/2014.



Kindest Regards,

Rod
Post #1527539
Posted Friday, January 03, 2014 7:45 AM
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: Thursday, April 10, 2014 1:08 PM
Points: 721, Visits: 1,264
john.kroneberger (1/2/2014)
also, make sure job is enabled.


The job is enabled.



Kindest Regards,

Rod
Post #1527541
Posted Friday, January 03, 2014 9:51 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 7:34 AM
Points: 485, Visits: 1,173
In addition to Enable Job, there is also a check box for Enable Schedule. It is on the screen where you Edit the schedule. Perhaps the schedule got disabled for some reason when the job was moved?


Post #1527631
Posted Friday, January 03, 2014 10:09 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 1:13 PM
Points: 604, Visits: 477
if it shows that it will run 2/1 then the schedule is enabled.

I'll revert back to, 'delete the schedule and make it again'


.
Post #1527640
Posted Friday, January 03, 2014 1:22 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: Thursday, April 10, 2014 1:08 PM
Points: 721, Visits: 1,264
Bill (DBAOnTheGo) (1/3/2014)
if it shows that it will run 2/1 then the schedule is enabled.

I'll revert back to, 'delete the schedule and make it again'


OK, Bill, I've taken your advice. I removed the schedule from the job and then created a new one, with a different name (I don't know if the old schedule is still out there or not). As it turns out that SQL job was the only one that used that schedule, so I don't harm anything else. Then I double checked it in Activity Monitor, and it now shows it as going to run on April 1st, which is what I want it to do.

Just out of curiosity, suppose I or someone else, were to run that SQL job manually before then? Will it still run on 4/1/2014 @ 12:05 AM? Or would it be rescheduled?



Kindest Regards,

Rod
Post #1527707
Posted Sunday, January 05, 2014 10:45 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 1:13 PM
Points: 604, Visits: 477
That is a good question. You have two easy options there.

1) Create a job that does something, anything. Maybe even select name from sys.databases
Set it to run based on that schedule. check that it's going to run april 1st. Now run it manually and then see if that changes

2) Run the job anyways and if the date changes, reset the schedule again.

Either of those should answer the question. My personal guess is that it will hold the correct schedule still, but I don't have my lab near me right now.


.
Post #1527968
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse