URGENT - can't run new jobs

Hi,
I've set up a new DB on a new SQL install.
I've set up a maintenance plan for the system tables and a separate job to backup the user DB.
Whenever I try to run (test) either of them they stop immediately. Also under "next scheduled run" in EM it says date/time unknown.

The error log shows this each time I try and run it.

2006-04-30 11:41:14 - ! [000] Unable to retrieve steps for job DB Backup Job for DB Maintenance Plan 'DB Maintenance System Tables'
2006-04-30 11:41:14 - ! [298] SQLServer Error: 229, SELECT permission denied on object 'sysjobservers', database 'msdb', owner 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp)
2006-04-30 11:41:14 - ! [298] SQLServer Error: 229, UPDATE permission denied on object 'sysjobservers', database 'msdb', owner 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp)
2006-04-30 11:41:14 - ! [298] SQLServer Error: 229, EXECUTE permission denied on object 'sp_sqlagent_log_jobhistory', database 'msdb', owner 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp)
LVL 29
QPRAsked:
Who is Participating?
 
ewildeConnect With a Mentor Commented:
you might need to set this property to false, apply it, and than reset it to true (because of a bug somewhere in SQL Server).
0
 
QPRAuthor Commented:
Panic over!
I had forgotten to give the NT account that runs the jobs SA privelidges on the new server.

But why does EM-SQL Agent-Jobs "next run date" show as date/time not available?
I've looked into the schedule part of the jobs and the schedule is set and enabled.
0
 
QPRAuthor Commented:
Just to confuse matters more... I just ran a job (non-maintencance plan) for a user DB.
It succeeded and now shows the date/time for the next schedule.
The jobs that run maintenance plans still show date/time unknown.

I looked on our development server and many of the jobs on there also show the same.
So it's an easy 500 points if someone can tell me why.
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
nito8300Commented:
Hi,

just because a job is enabled it doesn't mean it will run. go in the job properties and make sure the next run set is set to a future date.

Hope this helps,
Nito
0
 
QPRAuthor Commented:
Yes future date - overnight tonight.
The jobs on the development box have been running for months (with success) some of them say date/time unknown too
0
 
ewildeCommented:
you have permissions problem.
the jobs normaly run by the "SQL Server Agent", and it has properties for connecting to the database. it might be that the user that is defined for authenticate for "SQL Server Agent" dose not have enough permissions.

in enterprize manager go to folder: "Managment" and open the properties of "SQL Server Agent". in the "connection" tab check the "SQL Server Connection" properties.

ewilde.
0
 
QPRAuthor Commented:
How can I have permission problems?
The jobs run fun whether run manually or scheduled - just the "next scheduled run" date says unknown
0
 
ewildeCommented:
sorry, i didn't read your commecnts after the initial question.

as for the question as it looks right now, it looks like there is no enabled job-schedule for the jobs (there is another property for enabling the job, which is the one you see in the grid).

go to the properties of a job, open "schedules" tab, edit (one or more) of the job schedules and set the "enabled" property to true.

ewilde.
0
 
QPRAuthor Commented:
jobs and schedules are all enabled on both boxes.
jobs and schedules run as expected.
0
 
ewildeCommented:
if you set this property to false, and then back to true, as i suggested, you also need to refresh the "Jobs" node to see the changes in the grid
0
 
QPRAuthor Commented:
Apologies, I didn't read your post correctly.
That did the trick, thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.