SQL Jobs  
Author Message
dnapier





PostPosted: Sun Apr 10 23:54:12 CDT 2005 Top

SQL Server >> SQL Jobs

Dear Sir/Madam,

I have 2 things to ask:

1. Can we registered the SQL job inside the stored procedure.If Yes then
how?
2. Can we create Triggers from inside the stored procedure.If Yes then how?

can anubody share the code please.

Regards,
Ekta

SQL Server276  
 
 
Uri





PostPosted: Sun Apr 10 23:54:12 CDT 2005 Top

SQL Server >> SQL Jobs 1) Look at sp_add_job system stored procedure
2) CREATE TRIGGER my_tr ON Table you can write within a stored procedure

But question is DO YOU REALLY NEED IT?






> Dear Sir/Madam,
>
> I have 2 things to ask:
>
> 1. Can we registered the SQL job inside the stored procedure.If Yes then
> how?
> 2. Can we create Triggers from inside the stored procedure.If Yes then
how?
>
> can anubody share the code please.
>
> Regards,
> Ekta
>
>