Hi balasach82,

Lets say i have a job that is called Backup and my servername is BI-ONT this could be the query that you could use.

Update msdb..sysjobs

Set name = 'BI-ONT'+'_'+ name

where...

hey Matt.gyton,

Take a look at this topic i asked kind of the same thing.

http://www.sqlservercentral.com/Forums/Topic1404744-391-1.aspx

I haven't tested it yet.

Marbo

Hi ringovski,

I don't fully understand what your point is but isn't it simple to use a second send email task with probably a second variable or expression.

Or create a task...

Hi MyDoggieJessie,

Thanks for your reply.

I will try this in the next few days.

Martijn

sridhar_kola

If i understand you fully you have two jobs.

The first one calls the second through a executeSQL task correct?

The second job contains the other SQL statement that fails correct?

if this...

Hey,

I already found the solution.

instead of using the report manager services i need to use the report Server services.