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