The tag has no wiki summary.

learn more… | top users | synonyms

3
votes
2answers
215 views

Alert when Job isn't triggered

I have a Sql Job on my server that is triggered nightly from a remote server (once it has completed its backups). I have successfully configured the job to notify me when it fails, but I would like ...
0
votes
0answers
48 views

Receive Permission Denied error when scheduling a job in EnterpriseDB (Postgresql) V 9.1

I am attempting to schedule jobs in EnterpriseDB but receive the following error: WARNING: Query error: ERROR permission denied for relation pg_authid CONTEXT: SQL Statement SELECT jobloguser, ...
0
votes
1answer
134 views

Executing a SQL Job only once a month and after completion of a specific job

Let me better explain. My first job executes every 15 minutes (top of the hour, 12:15, 12:30 and 12:45). It does this for every day of the week. I have a second job that runs at 1:30 AM on the first ...
2
votes
0answers
1k views

How to clear an an Error 15404 after a DB restart (besides rebooting)

Every so often (e.g. ~months) a SQL Server Agent hourly Job will begin reporting an Error 15404 and continue to do so until intervened with. [298] SQLServer Error: 15404, Could not obtain ...
2
votes
1answer
4k views

How to run recurring tasks on a Postgresql database without a cron-like tool?

I would like to call a stored procedure on a regular basis. On Oracle, I would create a job for this. I have found that Postgresql can mimic this well by using an external tool (cron etc) and PgAgent. ...
4
votes
3answers
12k views

How to succesfully run a batch file in an SQL Agent job?

I have a SQL Agent Job which generates a specific report in PDF-file and then copies the PDF to a network directory and then deletes the PDF file in the source directory. The SQL Jobs consists of 2 ...
0
votes
1answer
93 views

sql job cancel triggers failure notification

When I cancel a sql agent job running an ssis package, I get a failure email because I set up the notifications to email when the Job Fails. Does anyone know why this is considered a 'failure'?
4
votes
2answers
592 views

Backup Only Database Schema Everynight

I have an instance with 15 databases on SQL Server 2012. I will set up to backup system which will work every night. I want to backup only the schema because several databases are very big. I haven't ...
4
votes
1answer
2k views

Agent job will not run

I created a JOB to run a simple package that runs a query and saves the results to an Excel file. If I try to run the job In SQL Management Studio I get an error saying: SQLServerAgent is not ...