jobs

Question

Viewing 6 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Jo Pattyn SSC-Dedicated Points: 32471 More actions · Answer 1

You can check this with sql Enterprise Manager usually.

Management->SQL Agent->Jobs->right-click show job history

Additional information can be found in the main sql server logs

Management->SQL Server logs

shiv-356842 SSCarpal Tunnel Points: 4312 More actions · Answer 2

Hi

I had created one job. Know i want to created Meassages to that jobfail or success

How can created Message for a specific job

Thx

Steve Jones - SSC Editor SSC Guru Points: 738683 More actions · Answer 3

I'm not sure what you are asking. Please specify in more detail what you'd like to do.

shiv-356842 SSCarpal Tunnel Points: 4312 More actions · Answer 4

Hi

I had created one job.

It will execute succesfully

Now i want to created Message for that job

Incase that job will be failes send Message that perticular clinet or user

How can create Message for that job.

Thx

Jo Pattyn SSC-Dedicated Points: 32471 More actions · Answer 5

If you rightclick on the job in enterprise manager and choose properties, there is a tab "Notifications" (usually the last one)

There you can set up "alerts" when the job completes or fails.