Is it possible to change the remote SQL Server Job Start time in C#

Posted by Vuyiswamb under Sql Server on 6/15/2011 | Points: 10 | Views : 2670 | Status : [Member] [MVP] [Administrator] | Replies : 3
Good Day all

i have a SQL Job and i want to change the times in the job programmatically from C#. The application that will change the Job Settings will be accessing the job remotely.

Is is possible ?

Thanks

Thank you for posting at Dotnetfunda
[Administrator]



Responses

Posted by: Robin_ahuja2008 on: 6/15/2011 [Member] Starter | Points: 25

Up
0
Down
Please check the link
http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.aspx

Regards,
Robin Ahuja

Vuyiswamb, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Vuyiswamb on: 6/15/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

Up
0
Down
Thanks i will look at it

Thank you for posting at Dotnetfunda
[Administrator]

Vuyiswamb, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: PandianS on: 6/15/2011 [Member] [MVP] Silver | Points: 25

Up
0
Down
Hi Vuyiswa

If you have a chance to change the JOB schedule activity through system stored procedures...

we have one system stored procedure called "sp_update_schedule" which is available in "msdb" database under "dbo" schema...
Exec msdb.dbo.sp_update_schedule <Parameters,........>
1. you have to create your own stored procedure with parameters(as required)
2. inside the stored procedure, you can access the system stored procedure... and pass the parameters(as required)
3. Call the stored procedure(your stored procedure) from the application and pass the parameters as per the setting, choosen from the application...

Cheers

Cheers
www.SQLServerbuddy.blogspot.com
iLink Multitech Solutions

Vuyiswamb, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response