Patch

If you update the SQL Server on your VCM install after the original installation you might run into the issue that you can't schedule any jobs anymore.

A quick fix can be achieved by the following SQL statement:


USE msdb
GRANT EXECUTE ON OBJECT::dbo.sp_add_category TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_job TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_jobschedule TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_jobserver TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_jobstep TO public
GRANT EXECUTE ON OBJECT::dbo.sp_add_schedule TO public Weiterlesen »