SQL Server JOBS

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

Mary
Thu Jun 17 08:10:28 CDT 2004

I don't think there's any way to do this directly from the alert. One
possibility might be to code the alert so that it writes a row in a
database table, which you can then query in your application. You also
might want to try posting the question in one of the sqlserver
newsgroups where SQL experts might have additional suggestions.

--Mary

On Wed, 16 Jun 2004 21:30:01 -0700, "Baren" <baren@india.com> wrote:

>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

Lloyd
Thu Jun 17 09:53:06 CDT 2004

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

baren
Thu Jun 17 23:25:01 CDT 2004

Hi! Lloyd,

I have a stored procedure which calls xp_cmdshell, which will send messages to the user. Now i will write a job which will call this stored procedure. Now the problem is how do i schedule it to run only after user logsin into the application and at the specified time only.

Regards,
Baren

"Lloyd Sheen" wrote:

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

Lloyd
Fri Jun 18 08:35:40 CDT 2004

Baren,
There are two sp's which you could use. The sp_add_jobschedule can be
used to create the schedule for the job to run and sp_delete_jobschedule can
be used to delete the schedule. When the user logs in use sp_add_schedule
specifying the time.

Lloyd Sheen

"Baren" <baren@india.com> wrote in message
news:704CDB07-91A3-4E7E-B312-121B6F9DB368@microsoft.com...
> Hi! Lloyd,
>
> I have a stored procedure which calls xp_cmdshell, which will send
messages to the user. Now i will write a job which will call this stored
procedure. Now the problem is how do i schedule it to run only after user
logsin into the application and at the specified time only.
>
> Regards,
> Baren
>
> "Lloyd Sheen" wrote:
>
> > 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
> >
> >
> >