simon-811452 (4/9/2010)

---

Brandie

This definitely happens when disabling from the GUI (see previous post). The system SP runs another SP, sp_sqlagent_notify, which clears the cache for the job; again, see previous post....

Could be..what do u mean by "job cache"..how can i check that?

crazy4sql (2/14/2011)

---

I no where said that job is created with same account. What I said was same...

Thanks. I am not looking for a solution here, as i mentioned in my post "ONLY FROM A SCRIPT" works. I...

crazy4sql (2/14/2011)

---

ii) i have a job which is running under a disabled windows account and still the job runs fine. How is this possible? The job owner is a disabled...

I will try to get some waitstats.

As far as i know there are no tables inside MSDB which will give the name of the "creator" of the job. I am so surprised that sql server...

DEPENDS....in our place we have one instance on each server but at my old place we had 2 instances on each server. Good thing about having multiple instances is you...

Grant Fritchey (2/14/2011)

---

For a) you want to take a look at the default trace. That's how you can tell who made structural changes to the system.

As far as b) goes,...

Grant Fritchey (2/14/2011)

---

Check the schedule on the job. It is probably disabled as well. Instead of disabling the job, if you disable/renable the schedule on the job I think you'l...

Ninja's_RGR'us (2/11/2011)

---

Unlikely. The problem with this setup if that you are basically downloading the whole table.

Unless you can bring that down to 3% and ideally very much less...

Ninja's_RGR'us (2/11/2011)

---

Without a where condition it CANNOT do anything else than a scan.

That being said, maybe it's not required.

Can you post table / keys / indexes defs, sample data and...

ChazMan (2/11/2011)

---

SQL can recompile specific lines within a stored procedure, which is what I think you are experiencing here. I would not worry about it unless there is a...

Thanks for your replies. Some more info on the issue

i) there are 5 different DML( NO DDL) going on with in the proc which i am working on

ii) each...

Grant what do you mean by "your queries are dynamic using EXEC "? When a task is selected from the application the sql behind the scene's is executed in "...