Jobs not running at all

Question

Post reply

Jobs not running at all

mannu_leo

SSChasing Mays

Points: 614
More actions
December 9, 2003 at 4:19 am

#64707

Whenever I try to run the job through Database Maintenance Plan and it does not run at all. And If I try to run it manually then it actually does nothing.
In the Next Run Date Column it says (Date and Time are not available) for any new
plans I create. When I right click and say start nothing happens. Its as if new
plans are not being recognized in the system but they are enabled and show up in
jobs.
I have checked the SQL Agent Services and these are running with the SysAdmin rights.

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

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

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Stupid question, but is the job activated?

Any entries in the job history?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

mannu_leo SSChasing Mays Points: 614 More actions · Answer 2

EXCUSE ME.......

now let me see whether u r able to resolve this issue and how long will it take for u to solve this.

the problem is that it is activated and there is no entry in the jobs history as well as in the SQL Error Logs coz probablly it never ran.

mannu_leo SSChasing Mays Points: 614 More actions · Answer 3

EXCUSE ME.......

now let me see whether u r able to resolve this issue and how long will it take for u to solve this.

the problem is that it is activated and there is no entry in the jobs history as well as in the SQL Error Logs coz probablly it never ran.

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

okay, a brainteaser for lunch time.

What does the job do?

Who owns it?

What steps are taken?

The steps are taken as which db user?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

mannu_leo SSChasing Mays Points: 614 More actions · Answer 5

well...

1) The job is simply taking a full Backup of one of the User Database which is coming through DB Maintenance Plan.

2) Its owner is sa

3) Just a single step of executing the Maintenance Plan which takes the full backup of a user db.

4) The steps are also owned by sa.

Whats ur MSN id by the way???

Frank Kalis SSC Guru Points: 111183 More actions · Answer 6

I have none!

What SQL Server version and SP are you running?

Did you create the maintenance plan via the wizard?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 7

Forgot to ask.

What do you mean by

quote:
I have checked the SQL Agent Services and these are running with the SysAdmin rights

does this account have appropriate permissions on the network?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

mannu_leo SSChasing Mays Points: 614 More actions · Answer 8

I am running SQL 2000 with SP3a on Windows 2000 Standard Server with SP4.

Yes I created the Maintenance Plan through Wizard only.

One more interesting thing is that if I make the plan for Transaction Log Backup then it works for that but not for full Backup.

Any clue...?

mannu_leo SSChasing Mays Points: 614 More actions · Answer 9

By this I mean that I have the Log On Account for SQL Server Agent who is having the appropriate permissions means that account has the sa rights in SQL Server and is a part of Local System Admin too.