How can i automate the process of log shipping monitoring I have log shipping configured between my Prod SQL server 2005 and QA SQL server 2005.        Per the requirement from Business we need to provide them with a report at the end of the day for the LOG shipping configured for multiple databases on their respective instances.

If i go manually and use standard reports, i am able to achieve this. But is there a way i can get such a report send via e-mail confirming the status of Log shipping configured amongst various DB;s in an instance.

Thanks
Kapil
The script below will give you most of the information from the standard reports in SSMS when executed on your secondary server.

select ls.primary_server,ls.primary_database,lsd.restore_delay,
DATEDIFF(mi,lms.last_restored_date,getdate()) as time_since_last_restore,
lms.last_copied_date,lms.last_restored_date,lms.last_copied_file,
lms.last_restored_file,
lsd.disconnect_users,ls.backup_source_directory,
ls.backup_destination_directory,ls.monitor_server


from msdb.dbo.log_shipping_secondary ls
join msdb.dbo.log_shipping_secondary_databases lsd
  on lsd.secondary_id=ls.secondary_id
join msdb.dbo.log_shipping_monitor_secondary lms
  on lms.secondary_id=lsd.secondary_id


You can then schedule this to run daily with a SQL Agent job or if you have SSRS you can easily schedule and format the report. 

If you go the SQL Agent route you will need to configure Database Mail and use that as your delivery service for the results of the query.