Hi,

Any one Kindly help me with this issue, if more details needed inform me

Thanks in advance.

Hi steve,

i copied the exact statemetns from log and even if i try to run on server load time it is displaying the same error.

Server load doesnt mean that 50%...

Hi,

Kindly help me to get this resolved so that my job is easier.

durai

the above query with a job is just specifying it's runnign status succesful or failure is it a way to schedule job email when no data returned for the query...

the backup is bappening only once in a day so i can schedule it after 30 mins after the backup schedule.

Hi sorry for replying late

thanks for your reply with that i have tried this.

select message from sysjobhistory

where step_name = 'Refresh'

and instance_id = ( select max(instance_id) from sysjobhistory

where step_name =...