Sure, here it is:

select 'exec sp_start_job @job_name = ''' + cast(j.name as varchar(40)) + ''''

from msdb.dbo.sysjobs j ...

Have a look at this.

http://blog.sqlauthority.com/2012/05/05/sql-server-migrate-a-sql-server-reports-from-one-server-to-another-server/

Here is a another option that I have personally used for migrating from 2005 to 2008 R2

http://thandor.net/article/28 -Look for the RSScripter.zip...

Did you try using something like REPLACE(REPLACE(YourField,CHAR(10),''),CHAR(13),'')

to modify the field from within the report query?

Thanks Steve. Good one.

Good question!

Good one, thanks!

Maybe try this?

http://www.dafont.com/code-128.font

Thanks Steve, nice one! 😀

Thanks for sharing! I do something similar but send a failure report instead. I then have a query that grabs the failed jobs, which I then copy and...

I'm not seeing an attachment.

What is the failure message saying? What is the dba looking at that suggests this one report is taking all the cpu?

Will it be start date, end date and effective date or start date and end date OR effective date?

Have a look at this.

http://www.rafael-salas.com/2007/03/ssis-file-system-task-move-and-rename.html#!/2007/03/ssis-file-system-task-move-and-rename.html

If you have a field in the header, make sure its size is as wide as the report. If it ends in the middle of one of the report...

Excellent question!

You're welcome!