This is the main step to create Job on SQL Server (2005 or above) with scripts :
1. for add job = sp_add_job 2. for add job steps = sp_add_jobstep
3. for add job schedule = sp_add_jobschedule 4. for add job target server = sp_add_jobserver
This complete scripts, you can download on this links.
Make better world with your passion.
1. for add job = sp_add_job 2. for add job steps = sp_add_jobstep
3. for add job schedule = sp_add_jobschedule 4. for add job target server = sp_add_jobserver
This complete scripts, you can download on this links.
Make better world with your passion.
No comments:
Post a Comment