Software is available from multiple vendors on external monitoring and scheduling task within SQL Server. Quest is one that is widely known in the industry for this but others...

I believe it would depend on what your packages are doing exactly. I would probably look at checking for a flag or some type of value if the package...

What is the purpose of doing that?

Most of the values you find in a MSDB table can be found in BOL: http://tinyurl.com/yc2crxx

Otherwise here they are for on_success_action, same applies for on_fail_action

1 = Quit the job...

larry.dano (1/15/2010)

---

I have a similar issue. I have a trace going on a specific application where we are experiencing some locking by the users. Around the time the...

Greg J (10/10/2005)

---

I've got a sql profiler session running right now with a filter on duration (> 300ms). I keep seeing a lot of HUGE duration events where event...

I would suggest starting up a trace file in Profiler and seeing if anything stands out to you, mainly look for excessive durations on stored procedures or T-SQL queries being...

A little more detail on your issue or question would allow for more detailed response/answer.

It was or it was not?

Jason Manthei-309857 (1/13/2010)

---

Both servers are run on VM on the same server and same set of disks. After the upgrade is done there is significantly more activity on the processor....

If you stop SQL Server Service does CPU drop below 100%?

What services of SQL Server 2005 did you install on the server? Is it fully patched?

What version of Window Server 2003? Is it updated and patched?

Well...

Well...there is something running on that server (CLIENT: xx.xx.xx.xx) that's trying to connect, at least from that error message. I am at bit of a loss on advice to...

My best guess is the problem lies with the PSFTP executable. I have not worked with this program much so I am not completely familar with it.

To verify you...