QPR
asked on
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_jobhistor y', database 'msdb', owner 'dbo'. [SQLSTATE 42000] (ConnExecuteCachableOp)
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_jobhistor
ASKER
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.
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.
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
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
ASKER
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
The jobs on the development box have been running for months (with success) some of them say date/time unknown too
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.
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.
ASKER
How can I have permission problems?
The jobs run fun whether run manually or scheduled - just the "next scheduled run" date says unknown
The jobs run fun whether run manually or scheduled - just the "next scheduled run" date says unknown
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
jobs and schedules are all enabled on both boxes.
jobs and schedules run as expected.
jobs and schedules run as expected.
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
ASKER
Apologies, I didn't read your post correctly.
That did the trick, thanks!
That did the trick, thanks!
ASKER
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.