Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Agent Job Creation Through .NET Expand / Collapse
Author
Message
Posted Wednesday, January 30, 2008 5:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, May 5, 2009 10:30 PM
Points: 5, Visits: 23
Dear Friends,

I have one requirement in my present project,
I have to create / delete / update SQL server agent jobs through NET 2.0 and i have to attach the schedule with that job. this also i need to with NET 2.0

Any one of you woks on this?
Please suggest me how do i do that

The SQL SRVR Ver: SQL SRVR 2005 Enterprise Edition


Thanks
Anantha



Kindest Regards,

AnanthaMarella

Post #449287
Posted Wednesday, January 30, 2008 4:37 PM
SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 4:39 PM
Points: 4,576, Visits: 8,342
Start Profiler.
Open EM.
Go to Maintenance -> SQL Server Agent -> Jobs.
Create a new job similarto what you wanr to create.

Go back to Profiler and find all scripts EM used to create the job.
Change names, replace fixed values like Start Date, Recurency, etc. with variables and use it in your application.
Post #449747
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse