Re: SQL Server JOBS

From: Lloyd Sheen (sqlguyremoveallofthis_at_tostopspamhotmail.com)
Date: 06/17/04 

Date: Thu, 17 Jun 2004 14:53:06 GMT

Baren,
    Are you trying to create jobs using DDL? If so there are a set of
stored procedures to both create and query jobs. The same is for Alerts.
For example the sp_add_job stored procedure will create a job. There are
many other procedures to use to get a job into a "runnable" state.
Depending on what information you need there are a set of sp_help_????
procedures to get the information you might be looking for.

    The best idea is to use Books Online for all the details.

Lloyd Sheen

"Baren" <baren@india.com> wrote in message
news:481CBBF1-E4F2-4711-9FD4-BDFF3F5C306E@microsoft.com...
> Hi!.
>
> I am developing a windows application where i need to give users alerts
about their pending jobs once they login into the application. I am trying
to create SQL Server jobs to give those alerts( If anyone has any other
option kindly post the same). now can anyone tell me how do i populate the
alert on the user machine.
>
> Thanks in advance
> Baren

Relevant Pages

  • Re: Group Multiple Jobs in Oracle Scheduler
    ... I need to be able to group jobs with common functionality. ... I have x amount of jobs (read stored procedures) that update my stock ... oracle so that job names, processing steps, status information, return ...
    (comp.databases.oracle.server)
  • Re: SQL Server JOBS
    ... > stored procedures to both create and query jobs. ... The same is for Alerts. ... >> I am developing a windows application where i need to give users alerts ...
    (microsoft.public.dotnet.framework.adonet)
  • Security for Jobs
    ... restart jobs when failure has occurred. ... are part of the 'Systems Administrators' Server Role to be ... Adminstrators' Server role. ... extended stored procedures and regular stored procedures. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions to view jobs but not change them
    ... Sorry, I meant view jobs... ... > Tibor Karaszi, SQL Server MVP ... >> is there any combination of permissions or a role that will let a user view ... >> stored procedures and their success without being able to modify them? ...
    (microsoft.public.sqlserver.server)
  • Re: newbie question
    ... > database for alerts, jobs, operators.... ... Is there any way to preserve any changes made to the MSDE environment? ...
    (microsoft.public.sqlserver.msde)