*** We are Self-Hosted ***
When trying to generate counts on an extraction in TEST, I'm getting the following message:
Error occurred while scheduling counts job: The EXECUTE permission was denied on the object 'sp_add_job', database 'msdb', schema 'dbo'.
I tried this from an older post but it didn't work::
use msdbgoEXEC sp_addrolemember 'SQLAgentUserRole', 'guest'go
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
**SOLVED**
ALTER DATABASE impresario SET TRUSTWORTHY ON;
I could have sworn I executed this yesterday. Tried it again this morning and ... problem solved.
UPDATE [dbo].[T_SANTA_LIST_CONTENTS]SET status = 'nice'Where status = 'naughty'and last_updated_dt > '2020-01-01'
Merry Christmas, Sir!
You are the most favorite friend I have made this year.
Heath, this post is BRILLIANT! It made my day.
Too bad I can't share it with more coworkers. I think only 1 would get the SQL/Tessitura database/List joke.
HA! It took me about 5 minutes of rewriting before I fell down the hole of "Surely Santa's move on from lists and now uses Plans!! Then I can join TR_Status" ... etc It's make for a great Tessiturian's Carol Singing