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 =...