Menu
SQL Server Agent is the job scheduling tool for SQL Server. To execute a job on demand using the GUI, open the SQL Server Agent tree, expand Jobs, select the job you want to run, right click on that job and click 'Start Job' and the job will execute.
Right click on SQL Server Agent, New, Job, and then Enter Job Name, Category, Description. Go to Steps tab, click New, enter step name, select Type of Step, select Database and then click OK.
To start, stop, or restart the SQL Server Agent Service In Object Explorer, click the plus sign to expand the server where you want to manage SQL Server Agent Service. Right-click SQL Server Agent, and then select either Start, Stop, or Restart. In the User Account Control dialog box, click Yes.
I've scheduled a job xyz in the SQL Server Job Agent. Now I want to invoke the job from my windows application.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With