SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


A SQL Job of mine isn't running. I don't know why not.


A SQL Job of mine isn't running. I don't know why not.

Author
Message
john.kroneberger
john.kroneberger
SSC Rookie
SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)SSC Rookie (38 reputation)

Group: General Forum Members
Points: 38 Visits: 298
also, make sure job is enabled.
Rod
Rod
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6851 Visits: 2170
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
Connect with me on LinkedIn.
Rod
Rod
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6851 Visits: 2170
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
Connect with me on LinkedIn.
Rod
Rod
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6851 Visits: 2170
john.kroneberger (1/2/2014)
also, make sure job is enabled.


The job is enabled.

Kindest Regards,Rod
Connect with me on LinkedIn.
Ed Zann
Ed Zann
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1898 Visits: 1398
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?



Bill (DBAOnTheGo)
Bill (DBAOnTheGo)
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1221 Visits: 599
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'

.
Rod
Rod
SSCertifiable
SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)SSCertifiable (6.9K reputation)

Group: General Forum Members
Points: 6851 Visits: 2170
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
Connect with me on LinkedIn.
Bill (DBAOnTheGo)
Bill (DBAOnTheGo)
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1221 Visits: 599
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.

.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search