news:1153418082.101143.305250@i3g2000cwc.googlegroups.com...
> Hi Guys,
>
> Is there any stored procedure or sql statement to add notification for
> a job? The senerio is i have to create a job by using sps and i cant
> find any procedure for enabling/disabling "write to application event
> log" or autodelete job option which we have in notifications tab.
>

> See sp_add_job in SQL Server Books Online. Also, the best way to get a
> proper script for jobs is to create the job interactively in Enterprise
> Manager, and then generate a script for that job. You can script a job by
> right clicking on it, and clicking the script option.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @ http://vyaskn.tripod.com/
>
>
>
> <ameen.abdul***@gmail.com> wrote in message
> news:1153418082.101143.305250@i3g2000cwc.googlegroups.com...
> > Hi Guys,
> >
> > Is there any stored procedure or sql statement to add notification for
> > a job? The senerio is i have to create a job by using sps and i cant
> > find any procedure for enabling/disabling "write to application event
> > log" or autodelete job option which we have in notifications tab.
> >