Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

sql 2012 - run a job

Hello,
I need to run a job in Sql server 2012. The service provider has added Sql Server Agent but I cannot see it in my Sql server management studio express 2012. What can I do to access it?
Greetings
0
johnson1
Asked:
johnson1
1 Solution
 
Peter HutchisonSenior Network Systems SpecialistCommented:
Its not possible to run sql jobs via the Studio Management Studio. Instead you can create jobs using a bit of Notepad, the SqlCmd.exe and the Task Scheduler.
Open notepad and save the sql statements in a .sql file on the server somewhere e.g. d:\MSSQL\Jobs.
Create a new Scheduled Task and run the sql file as a given user e.g.

Sqlcmd.exe -I script.sql -U username -P password

There are some third party Agents but you have to check the documentation that came with them.
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now