Is there a way of checking of a package schedule works??

[jermine]

i have a package set to run everyday, let's say at 4PM. I need to check if this package run successfully. If not could i send an alert to inform me that an error has occurred?

This can be done with jobs and jobsteps. im wonder if it can also do with packages.

thanks to anyone who takes time to read or reply to this!

 

[schu]

in sql 2000

database -> dbname->management->sql server agent -> jobs

open the job, then use the notification tab to set notifications.

you can set to email, write to event log etc.