[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 968
  • Last Modified:

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)
0
QPR
Asked:
QPR
  • 6
  • 4
1 Solution
 
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
 
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
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
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
 
ewildeCommented:
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:
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now