Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

sql 2012 - run a job

Posted on 2014-07-21
1
Medium Priority
?
263 Views
Last Modified: 2014-08-05
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
Comment
Question by:johnson1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 20

Accepted Solution

by:
Peter Hutchison earned 2000 total points
ID: 40208734
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

10 Questions to Ask when Buying Backup Software

Choosing the right backup solution for your organization can be a daunting task. To make the selection process easier, ask solution providers these 10 key questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

721 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question