Thanks for the speedy response John.

The SQL Agent login doesn't have SELECT permissions on msdb or master tables. That's all it needs to do. Just read data from system tables.

The script creates a stored procedure.

You need to run

exec USP_DBA_RECENTBACKUPS 'YourDBName' for backups for one database

or exec USP_DBA_RECENTBACKUPS by itself for backups of all DBs on the...

Hmmm....Jeff makes a good point.

You could add a notification to the job so you get an email on failure but what happens if the job hangs or doesn't start?

Another way...

With 45 cursors in one sproc he will never know which ones are taking the longest unless he implements some logging.

This is why I suggested he inserts a record into...

Excellent stuff! Nice one. 😀

selvakumar.sms (10/15/2012)

---

hi all

i have stored procedure with 45 cursor, so the stored procedure taking long time to finish. is it possible to get running time...

Okay so something like the below might work for you:

IF (select count(*) from [e009]) > 0

begin

exec msdb.dbo.sp_send_dbmail

@profile_name = 'Default',

@recipients = 'me@example.com',

@subject = 'warning',

@query = 'select * from [e009]',

@attach_query_result_as_file = 1,

@query_attachment_filename...

I didn't know that. My understanding...

Google is your best friend. But here goes anyway:

Differential backup - A file which contains ONLY the changes...

sqlrd22 (10/15/2012)

---

I have a job in SQL Server Agent that sends the results of a query to my email twice daily, however most of the time this query will not...

opc.three

Good point. Going with a third party tool would cost £7k+ which is just too much.

george sibbald

Another good point but there is something else I didn't mention in my...

Jason-299789 (10/11/2012)

---

Does that work when itterating through a record set of server names, as I thought that the connections were set only when the package was loaded and couldnt change...

dbaforever (10/11/2012)

---

hi experts,

I have a table that contains 1 column - ServerName varchar(50). It contains 40 rows or 40 unique server names.

My SSIS package loops thru each server name storing...

How dare you!!!!!!

Snooker is brilliant to watch... OMG the skills required it's incredible!

Parameter sniffing possibly?

http://www.simple-talk.com/sql/t-sql-programming/parameter-sniffing/