Solved

sql 2012 - run a job

Posted on 2014-07-21
1
249 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
1 Comment
 
LVL 19

Accepted Solution

by:
Peter Hutchison earned 500 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

809 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