How to schedule a SQL job from .net 2005

Can we still schedule a sql job from .net 2005 using sqldmo object?

Any pointers will be appreciated...

If you're developing a new application for SQL Server 2005, it is recommend that you use SQL SMO instead of DMO. DMO has been marked for deprecation and SQL SMO is taking its place.

Here is a link to the BOL docs for SMO and SQL Server Agent:
http://msdn2.microsoft.com/en-us/library/microsoft.sqlserver.management.smo.agent.aspx

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Appreciate your response.

I have a sql job which will run this SSIS package. If I were to write a SP which will do Exec sp_start_job and give the job name shouldnt this be lot easier...
i just want an Asyn process to start when the package is running so that user is completly oblivious abt the back end processing.

So I was wondering to call the sp_start_job in a sp and call this stored proc once the file upload is done...

But as expected I am running into permission starting a sp from msdb db...

Any idea how can I sue sp_start_job and execute this package?

Regards,

sql