Job Activity/Database Maintance Plan

Question

Post reply

Job Activity/Database Maintance Plan

Krasavita

SSC-Insane

Points: 23138
More actions
February 7, 2011 at 9:04 am

#144979

Hello,
For some reason all of my jobs are not running and not showing the next run date. I checked bunch of times when is next time job schedule,but next date run is not showing and jobs are not running. Can someone help me why is that?
Thank you

Viewing 9 posts - 1 through 8 (of 8 total)

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

SkyBVI SSCoach Points: 15128 More actions · Answer 1

I guess ,They have been just created and they didnot run until now.

see in job activity monitor, wat can u see about the jobs, last run, next run ?

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

SkyBVI SSCoach Points: 15128 More actions · Answer 2

what you meant by jobs are not running?

Were they scheduled to run and if it failed.

Can you post the code/error.

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 3

Is there a schedule set for the job? If you look in the properties, what does it say?

Is SQL Agent running?

Krasavita SSC-Insane Points: 23138 More actions · Answer 4

SQL agent is running, how to check if anything was canceled?

Thank you

Judy Why Hall of Fame Points: 3656 More actions · Answer 5

Can you check server date time setting? It might be wrong server date time.

SkyBVI SSCoach Points: 15128 More actions · Answer 6

go to the job --> properties

and then see the schedule

Regards,

Sushant

Regards
Sushant Kumar
MCTS,MCP

Krasavita SSC-Insane Points: 23138 More actions · Answer 7

For some reasons the problem was fixed and jobs are working now:

This is what I see in my error logs:

1.2011-02-04 08:30:04.73 spid3 Recovery complete.

2011-02-04 08:30:04.73 spid3 SQL global counter collection task is created.

2011-02-04 08:30:04.76 spid3 Launched startup procedure 'sp_MSrepl_startup'

2011-02-04 08:30:04.76 spid3 Launched startup procedure 'sp_MScleanupmergepublisher'

2011-02-07 11:59:09.05 spid98 Using 'xpsqlbot.dll' version '2000.80.2039' to execute extended stored procedure 'xp_qv'.

Can someone help me what is this mean?

Thank you

Steve Jones - SSC Editor SSC Guru Points: 736478 More actions · Answer 8

Not sure what's recovered. You'd have to look further up in the log, but this instance has two startup procedures that are being executed. You can mark a stored procedure to execute when the instance starts.