Grant execute explicitly to that procedure for the login being used.

What version of SSMS are you running?

What is compatibility level of database(s) you don't see intellisense work?

What query are your trying to execute to get job status?

I think you might want to define the user requirement in a bit more detail, or have the user provide it to you.

Are they looking to:

1. sort the output...

Repeat post of this question.

Just reposting the same question does not help much when folks do not have the information that was already discussed in your original question. As well,...

You already determined that the associated SQL Agent job for this scheduled report contains two schedules within the configuration of the Job. If it does indeed have that then that...

ramana3327 (9/10/2014)

---

Hi Shawn,

use msdb;

GO

select name, date_modified, enabled ,*from sysjobs where name='JobName'

when I use that query it is showing that the data_modified was last year. That means there is no...

Based on that it is likely someone modified the job from SQL Server Agent. Since these jobs are not supposed to be modified from that side I would suggest deleting...

The subscriptions are run by a SQL Agent job running, it tells the SSRS service that "hey you need to run this report". I would check to see if the...

<removed>

I am not aware of any options that are going to make it easy for you. I would suggest going ahead and redesigning your email process for SSIS. Since 2008...

jorgans14 (9/4/2014)

---

I know Express is limited in what functions it can provide. If I could talk this client into purchasing SQL Standard, would this help me achieve the task...

jorgans14 (9/3/2014)

---

This client has IRS requirements that require them to log everything. Especially anyone who looks at the finance tables. I've implemented triggers on all the tables to...

If this is a solution you are providing to multiple clients it is much more efficient to put any code in a procedure and not the SQL Agent job itself....

joepacelli (9/3/2014)

---

The code needs to be able to run on non-AlwaysOn environment's

For example, existing client on SQL Server 2008 R2 who updates to our latest release

Our goal is to be...