Hi everyone,
Not sure if there is a better forum than this for this question (sorry if there is!). I'm about to create a SQL Job (under SQL Server Agent) which will call several Stored Procedures, once every hour. The SPs will be sitting on the same server as the calling job. I haven't had any experience with SQL Jobs before and want to know whether I'd need to somehow grant execute permission to the job. I'm assuming no, because they're all sitting on the same server, but just wanted to check as I don't want any nasty surprises at implementation time! Any advice would be appreciated. Thanks,
Tom