Does the package run from within bids?

Guacamole

You can set an alert to text or email you.

You can also create a job that checks for any failed jobs and then emails job results to you.

FROM sys.dm_exec_query_stats AS qs

CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) AS qt

Within sys.dm_exec_sql_text there is a dbid field. Use the db_name() function to get the name of the database.

Does the sql server agent service account have permissions to the folder where the excel file resides?

Congrats Meredith!!!!!!!!!!!!!!!!!!!!!!!!!!!!

CPU is total_worker_time in that DMV

The best thing you can do there is to do what you think makes logical sense --- after discussing it with interested parties. It needs to make sense to...

The instance will function just fine.

I like to move my default path off of C in the first place. I also like to have a different path for each...

SQL Kiwi (9/11/2012)

---

The question didn't mention trace flag 610 (which would enable minimal-logging in this scenario) so I assumed it was off, and was rewarded with a green tick and...

Lynn Pettis (9/10/2012)

---

Just a note, I try to write all my code as if the database was case sensitive. If a table is named ZipCode, then that is how...

Lynn Pettis (9/7/2012)

---

Okay, an etiquette question as a Good Samaritan. How many times should you refuse money for helping a motorist with a disabled vehicle? I was walking...

Thanks for the question.

jasona.work (9/7/2012)

---

Ah, the feeling you get when you do something for yourself, from scratch, without finding someone elses' code to use...

Even if it is something that a seasoned DBA (not...

Lynn Pettis (9/7/2012)

---

TravisDBA (9/7/2012)

---

majorbloodnock (9/7/2012)

---

TravisDBA (9/7/2012)

---

It has been my experience at events like this that if security personnel do not directly see it happen, or on closed circuit camera, then...