Skip to main content
Planview Customer Success Center

Execute permission error when trying to enable the Billable option on an engagement

Symptoms

When editing an engagement and attempting to select the 'Billable' checkbox under the Billing information tab, the following is generated:

The EXECUTE permission was denied on the object 'sp_add_job", database 'msdb', schema 'dbo'

Reason

Missing permission on the database

Resolution

For Changepoint V2014 and older:

Rerun the script EnableSQLDependency from the installation media in Utilities\Porting SQL Databases

For Changepoint V2017 and newer:

EXEC DBM_EnableSqlDependency 'CPSQLUser'  -- replace CPSQLUser with the username your Changepoint website uses to connect to the database.

Or as a manual operation:

EXEC GrantCPmsdbAccess 'CPSQLUser' -- replace CPSQLUser with the username your Changepoint website uses to connect to the database.